Re: COPY and read-only transactions - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: COPY and read-only transactions
Date
Msg-id 20060330143020.GB16142@svana.org
Whole thread Raw
In response to COPY and read-only transactions  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Thu, Mar 30, 2006 at 02:20:04PM +0200, Peter Eisentraut wrote:
> I probably made the original mistake in the code, so I refrain from claiming
> to know anything about Boolean logic, but this note in the release notes
> doesn't seem right:
>
>   Fix the sense of the test for read-only transaction in COPY
>   The code formerly prohibited COPY TO, where it should prohibit COPY FROM.

COPY FROM STDIN   is copying FROM the user TO the database
COPY TO STDIN     is copying TO the user FROM the database

Does that help?

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY and read-only transactions
Next
From: Tom Lane
Date:
Subject: Re: control pg_hba.conf via SQL