From: | Douglas Trainor <trainor(at)uic(dot)edu> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | trainor(at)uic(dot)edu |
Subject: | COPY when 'filename' is a directory |
Date: | 2002-01-16 23:47:46 |
Message-ID: | 3C461122.98CC6E4D@uic.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-patches |
I'd like to report a bug in 7.1.3 psql (at least on a 64-bit Alpha Linux box).
Maybe someone can confirm this or maybe it's fixed in 7.2
The 7.1 documentation ( http://www.postgresql.org/idocs/index.php?sql-copy.html )
for COPY ala
COPY table FROM 'filename'
says that if it fails you get feedback "ERROR: reason" and if it succeeds
you get feedback "COPY". However, I goofed today and my filename was a
directory, and I did not get ERROR... Here is a simplified version
demonstrating the lack of ERROR:
fred(at)goo> psql goo
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
goo=# DROP TABLE goober;
DROP
goo=# CREATE TABLE goober ( family VARCHAR(25), x integer, y integer );
CREATE
goo=# COPY goober FROM '/usr/local/pgsql/';
COPY
goo=# select count(*) from goober;
count
-------
0
(1 row)
goo=# \q
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Beckstette | 2002-01-17 10:43:24 | Postmaster crash |
Previous Message | Vardan Gyurjyan | 2002-01-16 22:05:34 | jdbc:postgress problem. |
From | Date | Subject | |
---|---|---|---|
Next Message | Brent Verner | 2002-01-17 12:08:10 | Re: COPY when 'filename' is a directory |
Previous Message | Tom Lane | 2002-01-14 20:18:38 | Re: Patches for AIX builds.. |