| 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: | Whole Thread | Raw Message | 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
| 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 |