COPY when 'filename' is a directory

Поиск
Список
Период
Сортировка
От Douglas Trainor
Тема COPY when 'filename' is a directory
Дата
Msg-id 3C461122.98CC6E4D@uic.edu
обсуждение исходный текст
Ответы Re: COPY when 'filename' is a directory  (Brent Verner <brent@rcfile.org>)
Список pgsql-bugs
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@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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bug #561: typo in trigger.c
Следующее
От: "Michael Beckstette"
Дата:
Сообщение: Postmaster crash