Обсуждение: PostgreSQL COPY command

Поиск
Список
Период
Сортировка

PostgreSQL COPY command

От
Paul Friberg CEO - ISTI
Дата:
Hi all,

Does anyone know if there are plans to upgrade the
COPY command so it spits back some intelligent results
when it finishes. At the present time if it finds a bad
row or a non-unique key set, it simply quits out with a
statement:

    "resetting connection"

Which is not very informative. Let me know if this part of
the code needs working on. If nobody else is adding this,
I would be happy to dive in.

I could imagine this spitting out a message about a certain
line not passing muster, or even the total number of rows
in the file input/output being listed (as is now returned
with the INSERT/DELETE/UPDATE/SELECT commands).


Cheers,

Paul
--
 Paul Friberg - p.friberg@isti.com - http://www.isti.com
      (914) 256-9290 Office - (914) 256-9299 FAX
    ISTI==Instrumental Software Technologies, Inc.
Systems Integration and Software Development Specialists