Re: [BUG?] UPDATE with RETURNING tableoid

Поиск
Список
Период
Сортировка
От KaiGai Kohei
Тема Re: [BUG?] UPDATE with RETURNING tableoid
Дата
Msg-id 49485909.9010807@ak.jp.nec.com
обсуждение исходный текст
Ответ на Re: [BUG?] UPDATE with RETURNING tableoid  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Another issue in default-values patch: defaults expanded too soon
Следующее
От: "Robert Haas"
Дата:
Сообщение: Re: Another issue in default-values patch: defaults expanded too soon