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

Re: COPY view

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Hans-Juergen Schoenig <hs(at)cybertec(dot)at>,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: COPY view
Date: 2006-06-14 21:28:04
Message-ID: 20060614212804.GS34196@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Wed, Jun 14, 2006 at 05:19:44PM -0400, Bruce Momjian wrote:
> Hans-Juergen Schoenig wrote:
> > Bruce Momjian wrote:
> > >>I don't see why views should be special. Tables clearly should be 
> > >>because we can open them directly.
> > >>    
> > >>
> > >
> > >Ah, I didn't think of that.  Good idea.  So we don't need this patch?
> > >
> > >  
> > >
> > 
> > why do we agree on a patch, implement it and reject it then?
> > would be easier to reject it before actually implementing it ...
> > it is quite hard to explain to a customer that something is rejected 
> > after approval - even if things are written properly ...
> 
> Agreed.  The problem with this patch is that originally we just wanted
> views, and later the idea of putting a query in there was agreed on, so
> the feature request has changed over time.

BTW, one argument for allowing dumping out of views is that it means
they'd act more like tables; you just COPY viewname TO file.

Also, if copy from select doesn't make it into 8.2, then we should
absolutely put this patch in, so that users at least have something they
can use.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2006-06-14 21:36:25
Subject: Re: COPY view
Previous:From: Tom LaneDate: 2006-06-14 21:27:50
Subject: Re: postgresql and process titles

pgsql-patches by date

Next:From: Bruce MomjianDate: 2006-06-14 21:31:44
Subject: Re: COPY view
Previous:From: Bruce MomjianDate: 2006-06-14 21:27:43
Subject: Re: SQL/XML publishing function experimental patch II

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