Re: [BUG?] UPDATE with RETURNING tableoid - Mailing list pgsql-hackers

From KaiGai Kohei
Subject Re: [BUG?] UPDATE with RETURNING tableoid
Date
Msg-id 49485909.9010807@ak.jp.nec.com
Whole thread Raw
In response to Re: [BUG?] UPDATE with RETURNING tableoid  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> KaiGai Kohei <kaigai@ak.jp.nec.com> writes:
>> I found a strange behavior on the recent v8.4devel with/without
>> SE-PostgreSQL patch set. Can you reproduce the following behavior?
> 
>> When I use UPDATE statement with RETURNING clause which contains
>> references to "tableoid" system column, it returns InvalidOid.
>> (The correct valus is 16384 in this case.)
>> However, RETURNING clause with INSERT/DELETE statement works well.
> 
> Confirmed here, all the way back to 8.2.  I concur it's a bug.

http://git.postgresql.org/?p=postgresql.git;a=commitdiff;h=ab7c31031eb4c9fa73d92c19d55a8c7f8bbf4196

Thanks, I confirmed the update eliminates the bug.
-- 
OSS Platform Development Division, NEC
KaiGai Kohei <kaigai@ak.jp.nec.com>


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Another issue in default-values patch: defaults expanded too soon
Next
From: "Robert Haas"
Date:
Subject: Re: Another issue in default-values patch: defaults expanded too soon