Re: bug fix request

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> 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.

I'd like to see a test case for this in v3 protocol.  It was definitely
a problem before that, but I thought I fixed it.

> 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.

Disable tab completion, or don't paste tabs.  I don't think psql can be
expected to recognize that a tab is coming from pasted input.
        regards, tom lane