Re: duplicate columns with COPY - Mailing list pgsql-hackers

From NikhilS
Subject Re: duplicate columns with COPY
Date
Msg-id d3c4af540712200608o78b00034oae2d97cd6320748a@mail.gmail.com
Whole thread Raw
In response to Re: duplicate columns with COPY  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
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 otherwise. While it definitely makes sense for the FROM case maybe we could relax this for the COPY TO case.

Regards,
Nikhils
--
EnterpriseDB               http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: duplicate columns with COPY
Next
From: Greg Smith
Date:
Subject: Re: Sorting Improvements for 8.4