COPY TO looses on view

From: Steve Pothier <pothiers(at)aries(dot)tucson(dot)saic(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: COPY TO looses on view
Date: 2001-06-27 15:46:10
Message-ID: 200106271546.f5RFkAO22074@payson.tucson.saic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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).

I did this under:
psql (PostgreSQL) 7.1
Linux payson 2.2.16 #1 Thu Oct 5 01:30:41 GMT 2000 ppc unknown
&
Linux mallard 2.4.0-4GB #1 Wed Jan 24 15:55:09 GMT 2001 i686 unknown

This is a "Minor Annoyance" since there is a work around (by creating
a temp table from the view; see below).

Thank you for your care and feeding of PostgreSQL!

-sp-

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
hbase=> create view foo as select * from subject;
hbase=> CREATE

hbase=> select count(*) from subject;
hbase=> count
-------
1372
(1 row)

hbase=> copy foo to stdout
hbase-> ;
hbase=> copy foo to stdout;
hbase=> copy subject to stdout;
00001 \N \N \N \N
00002 \N \N \N \N
...
04054 \N \N M \N
hbase=> select count(*) from foo;
hbase=> count
-------
1372
(1 row)

hbase=> CREATE TEMP TABLE snafu AS SELECT * from foo;
hbase=> SELECT

hbase=> select count(*) from snafu;
hbase=> count
-------
1372
(1 row)

hbase=> copy snafu to stdout
hbase-> ;
00001 \N \N \N \N
00002 \N \N \N \N
...
04054 \N \N M \N

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-06-27 15:50:50 Re: COPY BINARY broken on Linux/AXP
Previous Message Reinhard Max 2001-06-27 15:34:43 Re: COPY BINARY broken on Linux/AXP