Skip site navigation (1) Skip section navigation (2)

Re: COPY and read-only transactions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: COPY and read-only transactions
Date: 2006-03-30 14:29:26
Message-ID: 14395.1143728966@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> 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.

No, it's correct --- the directions are COPY table TO file or COPY table
FROM file.  The FROM case is therefore the one that changes the database.

I've always found that directionality nonintuitive, but it's surely far
too late to reverse the sense.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Martijn van OosterhoutDate: 2006-03-30 14:30:20
Subject: Re: COPY and read-only transactions
Previous:From: Tino WildenhainDate: 2006-03-30 14:28:14
Subject: Re: control pg_hba.conf via SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group