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

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

From

momjian@svr1.postgresql.org (Bruce Momjian)

Date:

06 April 2004, 10:21:37

CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    momjian@svr1.postgresql.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