Re: Allowing COPY into views - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: Allowing COPY into views
Date
Msg-id 87mz14f24q.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Allowing COPY into views  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Allowing COPY into views  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
"Alvaro Herrera" <alvherre@commandprompt.com> writes:

> The threads to updatable views have concluded rejecting the patches, and
> with ideas that require rather extensive rewriting of the rule manager,

I have some ideas on a different approach to this if anyone's thinking of
starting fresh but I had the impression that the patches were rejected because
they were unnecessarily complex, not because the overall approach was
rejected.

> Updatable views are not going to handle COPY anyway ...

Well I noticed this as I was writing it. Even once you have updateable views
you would still have to have code in COPY supporting creating insert
statements which isn't how it works now.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Fixing insecure security definer functions
Next
From: Alvaro Herrera
Date:
Subject: Re: Allowing COPY into views