Re: Allowing COPY into views

From: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Allowing COPY into views
Date: 2007-04-19 14:22:20
Message-ID: 1176992540l.10180l.2l@mofo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)meme(dot)com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message William Lawrance 2007-04-19 14:23:22 BUG #3244: problem with PREPARE
Previous Message Karl O. Pinc 2007-04-19 13:41:55 Allowing COPY into views