Re: [HACKERS] COPY view

From: Böszörményi Zoltán <zboszor(at)dunaweb(dot)hu>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org, "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Hans-Juergen Schoenig" <hs(at)cybertec(dot)at>, "Stefan Kaltenbrunner" <stefan(at)kaltenbrunner(dot)cc>, "Bruce Momjian" <bruce(at)momjian(dot)us>, "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Andrew Dunstan" <andrew(at)dunslane(dot)net>, "Karel Zak" <zakkr(at)zf(dot)jcu(dot)cz>, "List pgsql-patches" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] COPY view
Date: 2006-08-23 06:38:27
Message-ID: 2044.213.163.11.81.1156315107.squirrel@www.dunaweb.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Hi,

> Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
>> On Tuesday 22 August 2006 16:10, Tom Lane wrote:
>>> As I see it, we've effectively got a patch that was rejected once,
>>> and Bruce wants to apply it anyway because no replacement has been
>>> forthcoming.
>
>> Well, unless someone is going to commit to doing it the other way, it
>> seems
>> the guy who actually codes something offers a better solution than
>> handwaving... people have also had plenty of time to come up with a
>> replacement if that's what they really wanted.
>
> The patch submitter has neither provided an updated patch nor defended
> his original submission as being the right thing. If he doesn't take it
> seriously enough to have done any followup, why should the rest of us?
>
> At the moment, with the online-index and updatable-views patches both
> pretty seriously broken, and no sign that the bitmap-index people are
> awake at all, I might take it on myself to fix this one instead of those
> others. But is that what I should be spending my time on in the waning
> days of the 8.2 freeze cycle? Speak now or hold your peace.
>
> regards, tom lane

I am willing to get it up to shape and support
both COPY (select) TO and COPY view TO,
the second is rewritten as SELECT * FROM view.
In fact, I already started.

Best regards,
Zoltán Böszörményi

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zdenek Kotala 2006-08-23 06:47:03 Problem with mailing list?
Previous Message Tom Lane 2006-08-23 05:52:34 Re: Some minor changes to pgbench

Browse pgsql-patches by date

  From Date Subject
Next Message Dave Page 2006-08-23 07:10:23 Re: pgsql-patches reply-to (was Re: [PATCHES] selecting large result sets in psql using cursors)
Previous Message Tom Lane 2006-08-23 05:52:34 Re: Some minor changes to pgbench