Skip site navigation (1) Skip section navigation (2)

bug fix request

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: bug fix request
Date: 2004-11-29 04:24:02
Message-ID: 41AAA462.8050708@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-hackers
I would like to beg for some sort of fix to psql's handling of COPY data 
if the COPY fails.

Presently you get a million lines of '\N command not recognised' and 
various other random things because if a line of the copy fails due to 
say a FK constraint, or even if the COPY is run in an aborted 
transaction, it tries to execute all the stdin data as actual 
statements.  It's really, really, really annoying.

Also, sometimes when you copy and paste SQL into a psql window, it 
executes help on commands for each line, although it doesn't affect the 
paste.  That is also really annoying.  I'll add to this email when it 
happens to me again, cos I tried a few pastes and couldn't reproduce it :/

Chris

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2004-11-29 04:59:39
Subject: Re: multiline CSV fields
Previous:From: Neil ConwayDate: 2004-11-29 04:06:55
Subject: Re: -V, --version -- deprecated?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group