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.

regards, tom lane