Re: BUG #8275: Updateable View based on inheritance (partition) throws Error on INSERT Statement

Поиск
Список
Период
Сортировка
От Dean Rasheed
Тема Re: BUG #8275: Updateable View based on inheritance (partition) throws Error on INSERT Statement
Дата
Msg-id CAEZATCW4EUi-BqjzYyow0nt84jhOwSDxzbhtbFoRrvUi59NCnQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #8275: Updateable View based on inheritance (partition) throws Error on INSERT Statement  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Ответы Re: BUG #8275: Updateable View based on inheritance (partition) throws Error on INSERT Statement  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
On 2 July 2013 09:30, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
> I think the rewritten query should only use inheritance if inheritance
> was requested in the original query, *and* if inheritance was enabled
> in the view's query, per attached patch against HEAD.

On second thoughts, I think this should only apply to INSERT.

UPDATE and DELETE should continue work the same as SELECT, respecting
the inheritance flag from the view query regardless of the inheritance
flag in the outer query.

Attached is an updated patch for HEAD, with regression tests. This
should also be applied to the 9.3beta branch.

Regards,
Dean
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Postgres crash? could not write to log file: No space left on device
Следующее
От: valeriy.smirnov@itv.ru
Дата:
Сообщение: BUG #8276: Can't install PostgreSQL with russian name for OS user