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

From Tom Lane
Subject Re: [BUG?] UPDATE with RETURNING tableoid
Date
Msg-id 29130.1229439384@sss.pgh.pa.us
Whole thread Raw
In response to [BUG?] UPDATE with RETURNING tableoid  (KaiGai Kohei <kaigai@ak.jp.nec.com>)
Responses Re: [BUG?] UPDATE with RETURNING tableoid  (KaiGai Kohei <kaigai@ak.jp.nec.com>)
List pgsql-hackers
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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Lor
Date:
Subject: Re: DTrace probes patch
Next
From: Peter Eisentraut
Date:
Subject: Re: SQL/MED compatible connection manager