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

Re: COPY view

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
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:36:25
Message-ID: 200606142136.k5ELaPE26801@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Jim C. Nasby wrote:
> 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.

I think the simple argument is that you can SELECT from a table, why not
COPY from it.  Of course copying INTO a view would not work.  :-(

-- 
  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-06-14 21:40:47
Subject: Re: timezones to own config file
Previous:From: Jim C. NasbyDate: 2006-06-14 21:28:04
Subject: Re: COPY view

pgsql-patches by date

Next:From: Bruce MomjianDate: 2006-06-14 22:08:59
Subject: Re: TODO item - tid <> operator
Previous:From: Bruce MomjianDate: 2006-06-14 21:35:22
Subject: Re: COPY view

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