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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
Cc: exclusion(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18546: Attempt to insert default into a non-updatable column of a view fails with a dubious error
Date: 2024-07-22 14:31:21
Message-ID: 868880.1721658681@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> writes:
> 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.

No objection here.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Mohammed Siddiqui 2024-07-22 14:46:59 Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database.
Previous Message Sandeep Thakkar 2024-07-22 12:12:41 Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607