| From: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
|---|---|
| To: | Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #8275: Updateable View based on inheritance (partition) throws Error on INSERT Statement |
| Date: | 2013-07-02 10:42:58 |
| Message-ID: | CAEZATCW4EUi-BqjzYyow0nt84jhOwSDxzbhtbFoRrvUi59NCnQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 2 July 2013 09:30, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)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 | Content-Type | Size |
|---|---|---|
| updatable-views-inh.patch | application/octet-stream | 4.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2013-07-02 11:05:36 | Re: [BUGS] BUG #7873: pg_restore --clean tries to drop tables that don't exist |
| Previous Message | Pavel Stehule | 2013-07-02 09:39:50 | Re: [BUGS] BUG #7873: pg_restore --clean tries to drop tables that don't exist |