From: | Bob Parkinson <rwp(at)biome(dot)ac(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump/load quoting. |
Date: | 2000-06-29 16:24:52 |
Message-ID: | Pine.OSF.4.21.0006291704240.23050-100000@omni.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear All,
pg_dump is dumping INSERT commands that fail to reload.
I'm putting stuff into a table using perl DBI; dbh->quote. A select
shows a row like:
1047676 | 1047673 | CAB | breeders' associations
pg_dump creates a line
INSERT INTO "keywords" ("key","extkey","system","str") VALUES (1047676,1047673,'CAB','breeders'' associations');
which throws a parser editor when I try to reload it.
dev_templates=# INSERT INTO
"keywords" ("key","extkey","system","str") VALUES
(1047676,1047673,'CAB','breeders'' associations');
ERROR: parser: parse error at or near "associations"
Whats happening please? Its quoted correctly, isn't it? I've just read the
example/para about 'dianne''s horse'
Cheers,
Bob
Bob Parkinson
rwp(at)biome(dot)ac(dot)uk
------------------------------------------------------------------
Technical Manager: Biome http://biome.ac.uk/
Greenfield Medical Library,
Queens Medical Centre,
Nottingham. 0115 9249924 x 42059
------------------------------------------------------------------
We are stardust
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2000-06-29 16:27:47 | Re: Comments with embedded single quotes |
Previous Message | Tom Lane | 2000-06-29 16:09:10 | Re: NOTICE messages during table drop |