Re: COPY TO looses on view

Поиск
Список
Период
Сортировка
От Steve Pothier
Тема Re: COPY TO looses on view
Дата
Msg-id 200106281518.f5SFIkv28332@payson.tucson.saic.com
обсуждение исходный текст
Ответ на Re: COPY TO looses on view  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: COPY TO looses on view  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: 鍾子帆
Дата:
Сообщение: setup postgresql problems ???
Следующее
От: "Rod Taylor"
Дата:
Сообщение: Foreign Keys and ALTER RENAME TABLE