Re: duplicate columns with COPY

From: NikhilS <nikkhils(at)gmail(dot)com>
To: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: duplicate columns with COPY
Date: 2007-12-20 14:08:36
Message-ID: d3c4af540712200608o78b00034oae2d97cd6320748a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Smith 2007-12-20 14:41:13 Re: Sorting Improvements for 8.4
Previous Message Andrew Dunstan 2007-12-20 14:01:47 Re: duplicate columns with COPY