On Monday 29 November 2004 02:58, Christopher Kings-Lynne wrote:
> > Hmm. This error is not coming from "a line of the copy", it is occurring
> > because the COPY command itself fails, and so the server never tells
> > psql to shift into COPY mode. I'm not sure that a reasonable fix for
> > this
Tom Lane <[EMAIL PROTECTED]> writes:
> 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.
Hm, this also bother me all the time. It doesn't sound like it would be very
hard to detect pasted tabs actually. Two opti
Hmm. This error is not coming from "a line of the copy", it is occurring
because the COPY command itself fails, and so the server never tells
psql to shift into COPY mode. I'm not sure that a reasonable fix for
this is possible. As a counterexample, if you misspelled COPY as COPZ,
would you expe
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> 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 a
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 t
Christopher Kings-Lynne <[EMAIL PROTECTED]> 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
> s
Christopher Kings-Lynne wrote:
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
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
