Re: Allowing COPY into views

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