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

From Karl O. Pinc
Subject Re: Allowing COPY into views
Date
Msg-id 1176992540l.10180l.2l@mofo
Whole thread Raw
In response to Allowing COPY into views  ("Karl O. Pinc" <kop@meme.com>)
Responses Re: Allowing COPY into views  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
On 04/19/2007 08:41:55 AM, Karl O. Pinc wrote:

> I would like to submit a patch so that the
> COPY statement can import data into a view.

> 2) Allocate memory for char* and construct an
> 'INSERT ...' statement corresponding
> to the COPY command that inserts into the view.
> (Just how much memory should be allocated?
> Is there a standard buffer pre-alocated somewhere or a
> standard buffer size?)

I'll use a StringInfo.

And I forgot, the final step is to add regression
tests.  One for view with an INSERT rule and one
to catch the error for a view without an INSERT rule.

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."                 -- Robert A. Heinlein



pgsql-hackers by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Allowing COPY into views
Next
From: Andrew Dunstan
Date:
Subject: Re: Allowing COPY into views