Re: [BUG?] UPDATE with RETURNING tableoid

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: KaiGai Kohei <kaigai(at)ak(dot)jp(dot)nec(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [BUG?] UPDATE with RETURNING tableoid
Date: 2008-12-16 14:56:24
Message-ID: 29130.1229439384@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

KaiGai Kohei <kaigai(at)ak(dot)jp(dot)nec(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2008-12-16 15:43:22 Re: pgsql: Append major version number and for libraries soname major
Previous Message Tom Lane 2008-12-16 14:53:26 Re: pgsql: Append major version number and for libraries soname major