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

pgsql-server/src/backend/commands copy.c

From: momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server/src/backend/commands copy.c
Date: 2004-04-06 13:21:33
Message-ID: 20040406132133.E6DA0D1EA67@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
CVSROOT:	/cvsroot
Module name:	pgsql-server
Changes by:	momjian(at)svr1(dot)postgresql(dot)org	04/04/06 10:21:33

Modified files:
	src/backend/commands: copy.c 

Log message:
	The attached applied patch throws an error if the delimiter appears in
	the COPY NULL string:
	
	test=> copy pg_language to '/tmp/x' with delimiter '|';
	COPY
	test=> copy pg_language to '/tmp/x' with delimiter '|' null '|x';
	ERROR:  COPY delimiter must not appear in the NULL specification
	test=> copy pg_language from '/tmp/x' with delimiter '|' null '|x';
	ERROR:  COPY delimiter must not appear in the NULL specification
	
	It also throws an error if it conflicts with the default NULL string:
	
	test=> copy pg_language to '/tmp/x' with delimiter '\\';
	ERROR:  COPY delimiter must not appear in the NULL specification
	test=> copy pg_language to '/tmp/x' with delimiter '\\' NULL 'x';
	COPY


pgsql-committers by date

Next:From: Bruce MomjianDate: 2004-04-06 13:55:17
Subject: pgsql-server/src/tools/thread thread_test.c
Previous:From: Bruce MomjianDate: 2004-04-06 04:05:18
Subject: pgsql-server/src/bin/psql describe.c

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