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

pgsql-server/ oc/src/sgml/ref/copy.sgml rc/bac ...

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server/ oc/src/sgml/ref/copy.sgml rc/bac ...
Date: 2003-10-06 02:38:53
Message-ID: 20031006023853.69C7ED1B50E@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
CVSROOT:	/cvsroot
Module name:	pgsql-server
Changes by:	tgl(at)svr1(dot)postgresql(dot)org	03/10/05 23:38:53

Modified files:
	doc/src/sgml/ref: copy.sgml 
	src/backend/commands: copy.c 

Log message:
	Modify COPY FROM to match the null-value string against the column value
	before it is de-backslashed, not after.  This allows the null string \N
	to be reliably distinguished from the data value \N (which must be
	represented as \\N).  Per bug report from Manfred Koizar ... but it's
	amazing this hasn't been reported before ...
	Also, be consistent about encoding conversion for null string: the form
	specified in the command is in the server encoding, but what is sent
	to/from client must be in client encoding.  This never worked quite
	right before either.


Responses

pgsql-committers by date

Next:From: Neil ConwayDate: 2003-10-06 03:34:03
Subject: Re: pgsql-server/ oc/src/sgml/ref/copy.sgml rc/bac ...
Previous:From: Tom LaneDate: 2003-10-06 01:11:13
Subject: pgsql-server/src/bin/psql common.c

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