Re: COPY TO looses on view

>
> Thank _you_.
>
> I didn't see anything in the documentation under COPY TO that
> indicated it should not work with views. Since you say it should
> raise and error, the documentation should probably be updated too.
>
> -Steve Pothier-
>
> Date: Thu, 28 Jun 2001 10:56:29 -0400
> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Cc: pgsql-bugs(at)postgresql(dot)org
>
> Steve Pothier <pothiers(at)aries(dot)tucson(dot)saic(dot)com> writes:
> > I created a simple view from an existing table. I can select on the
> > view ok but COPY TO "does nothing" (no error, no output).
>
> It should raise an error. Thanks for pointing that out.

OK, the following patch throws an error if you try to COPY TO/FROM
views.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026