Re: BUG #8275: Updateable View based on inheritance (partition) throws Error on INSERT Statement - Mailing list pgsql-bugs

From Dean Rasheed
Subject Re: BUG #8275: Updateable View based on inheritance (partition) throws Error on INSERT Statement
Date
Msg-id CAEZATCW4EUi-BqjzYyow0nt84jhOwSDxzbhtbFoRrvUi59NCnQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #8275: Updateable View based on inheritance (partition) throws Error on INSERT Statement  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: BUG #8275: Updateable View based on inheritance (partition) throws Error on INSERT Statement
List 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

Attachment

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Postgres crash? could not write to log file: No space left on device
Next
From: valeriy.smirnov@itv.ru
Date:
Subject: BUG #8276: Can't install PostgreSQL with russian name for OS user