Am Donnerstag, 20. Dezember 2007 schrieb Tom Lane:
I think it's reasonable even for COPY TO, since IMHO the odds that it's
a typo, rather than intentional, are probably 100:1.
ISTM that with this line of argument we could disable thousands of valid uses
of SQL commands.
--
Peter Eisentraut
Is there a reason why COPY TO STDOUT does not allow columns to be specified
more than once?
pei=# copy test1 (a, a) to stdout;
ERROR: 42701: column a specified more than once
Or is this just an overly extensive check that is actually intended for COPY
FROM STDIN?
--
Peter Eisentraut
Peter Eisentraut wrote:
Is there a reason why COPY TO STDOUT does not allow columns to be specified
more than once?
pei=# copy test1 (a, a) to stdout;
ERROR: 42701: column a specified more than once
Or is this just an overly extensive check that is actually intended for COPY
FROM STDIN?
Hi,
pei=# copy test1 (a, a) to stdout;
ERROR: 42701: column a specified more than once
Or is this just an overly extensive check that is actually intended for
COPY
FROM STDIN?
This seems to be a common check in both COPY TO and COPY FROM cases
source/destination being STDIN or
Peter Eisentraut [EMAIL PROTECTED] writes:
Is there a reason why COPY TO STDOUT does not allow columns to be specified
more than once?
pei=# copy test1 (a, a) to stdout;
ERROR: 42701: column a specified more than once
Or is this just an overly extensive check that is actually intended for