PostgreSQL COPY command

From: Paul Friberg CEO - ISTI <p(dot)friberg(at)isti(dot)com>
To: pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: PostgreSQL COPY command
Date: 1998-10-19 13:03:39
Message-ID: 362B38AB.BCFFE717@isti.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

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(dot)friberg(at)isti(dot)com - http://www.isti.com
(914) 256-9290 Office - (914) 256-9299 FAX
ISTI==Instrumental Software Technologies, Inc.
Systems Integration and Software Development Specialists

Browse pgsql-hackers by date

  From Date Subject
Next Message Sferacarta Software 1998-10-19 13:21:35 pg_dump bug
Previous Message D'Arcy J.M. Cain 1998-10-19 12:44:57 Re: [HACKERS] Re: inet/cidr/bind

Browse pgsql-sql by date

  From Date Subject
Next Message Gene Selkov Jr. 1998-10-19 13:33:23 Re: [SQL] [SQL, regex, words] how to match word boundaries using regex's?
Previous Message Tony.Curtis 1998-10-19 13:02:32 [SQL, regex, words] how to match word boundaries using regex's?