Re: Minor inheritance/check bug: Inconsistent behavior - Mailing list pgsql-bugs

From Amit Kapila
Subject Re: Minor inheritance/check bug: Inconsistent behavior
Date
Msg-id 004a01cd8509$7e2f95a0$7a8ec0e0$@kapila@huawei.com
Whole thread Raw
In response to Re: Minor inheritance/check bug: Inconsistent behavior  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Tuesday, August 28, 2012 2:04 AM
Robert Haas <robertmhaas@gmail.com> writes:
>> Maybe, but in that case shouldn't referencing a system column chuck an
error?

> Yeah, possibly.  I think none of them are populated with anything useful
> during INSERT checks (though OID might be an exception?).  Less sure
> about the state during UPDATE checks, though.

  AFAICT during Update also, it doesn't contain useful. The only chance it
would have contain something useful is when it goes for EvalPlanQual and
then again comes to check for constraints. However these attributes get
filled in heap_update much later.

So now should the fix be that it returns an error for system column
reference except for OID case?

With Regards,
Amit Kapila.

pgsql-bugs by date:

Previous
From: Chris Travers
Date:
Subject: Re: Minor inheritance/check bug: Inconsistent behavior
Next
From: Ryan Kelly
Date:
Subject: Re: [PATCH] Prevent hanging on unreachable hosts on startup