Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] COPY view

From: Böszörményi Zoltán <zboszor(at)dunaweb(dot)hu>
To: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"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>,"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 13:07:35
Message-ID: 4551.213.163.11.81.1156338455.squirrel@www.dunaweb.hu (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Hi,

> Tom Lane wrote:
>>
>> 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.
>>
>>
>>
>
> Personally, I would say that this is less important than updatable views
> but more than  online indexes. If it could be fixed just for the view
> case in a day or so then I think it's worth it.
>
> cheers
>
> andrew

It seems I was able to get it working for both the VIEW and SELECT
cases. I still have one issue, the reference to the select is left open
and it complains on closing the transaction. But basically works.

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


In response to

Responses

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2006-08-23 13:16:46
Subject: Re: [HACKERS] COPY view
Previous:From: Bruce MomjianDate: 2006-08-23 13:05:29
Subject: Re: Allow commenting of variables in

pgsql-patches by date

Next:From: Andrew DunstanDate: 2006-08-23 13:16:46
Subject: Re: [HACKERS] COPY view
Previous:From: Bruce MomjianDate: 2006-08-23 13:05:29
Subject: Re: Allow commenting of variables in

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group