Re: BUG #18546: Attempt to insert default into a non-updatable column of a view fails with a dubious error - Mailing list pgsql-bugs

From Dean Rasheed
Subject Re: BUG #18546: Attempt to insert default into a non-updatable column of a view fails with a dubious error
Date
Msg-id CAEZATCWLfKrE7m0pNMD3-5GCk=swfZWUMmatvHqDPMO9KNa3Vg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18546: Attempt to insert default into a non-updatable column of a view fails with a dubious error  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #18546: Attempt to insert default into a non-updatable column of a view fails with a dubious error
List pgsql-bugs
On Sat, 20 Jul 2024 at 17:26, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> The existing code/comments (dating AFAICS to Dean's cab5dc5da)
> already point out that rewriteTargetListIU can add targetlist items,
> but we missed the fact that it can delete them too.  So it seems like
> what we need to do is union the original set of target columns with
> what's listed in the targetlist, as attached.
>

Ah yes, that makes sense and the fix looks good. Thanks for taking care of that.

I had always thought that rewriteTargetListIU() only ever added or
merged items, somehow overlooking the fact that it could also delete
them. In my defence, it's very easy to get that impression just by
reading the function's comments. I think it's worth updating those
comments to mention that. Something like the attached, perhaps.

Regards,
Dean

Attachment

pgsql-bugs by date:

Previous
From: "Jason ChenTJ (CN)"
Date:
Subject: 回复: [External]Re: BUG #18540: Does PG16 standby database support function pg_replication_origin_advance?
Next
From: Andrew Dunstan
Date:
Subject: Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607