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@biome.ac.uk
------------------------------------------------------------------
Technical Manager: Biome http://biome.ac.uk/
Greenfield Medical Library,
Queens Medical Centre,
Nottingham. 0115 9249924 x 42059
------------------------------------------------------------------
We are stardust