Re: COPY TO looses on view - Mailing list pgsql-bugs

From Steve Pothier
Subject Re: COPY TO looses on view
Date
Msg-id 200106281518.f5SFIkv28332@payson.tucson.saic.com
Whole thread Raw
In response to Re: COPY TO looses on view  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: COPY TO looses on view
List pgsql-bugs
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@sss.pgh.pa.us>
   Cc: pgsql-bugs@postgresql.org

   Steve Pothier <pothiers@aries.tucson.saic.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

pgsql-bugs by date:

Previous
From: 鍾子帆
Date:
Subject: setup postgresql problems ???
Next
From: "Rod Taylor"
Date:
Subject: Foreign Keys and ALTER RENAME TABLE