Mon Mar 08 21:51:23 2010nick.phillips [...] otago.ac.nz - Ticket created
Subject:
PostgreSQL parser barfs on "ALTER DOMAIN"
Date:
Tue, 09 Mar 2010 15:49:28 +1300
To:
bug-SQL-Translator [...] rt.cpan.org
From:
Nick Phillips <nick.phillips [...] otago.ac.nz>
Trying to parse a schema dumped by pg_dump, the PostgreSQL parser barfs
on the line:
ALTER DOMAIN public.aclevel OWNER TO dba;
Which is unfortunate, as there are a lot of lines like that in the
dump...
Cheers,
Nick
--
Nick Phillips / +64 3 479 4195 / nick.phillips@otago.ac.nz
# these statements are my own, not those of the University of Otago
Thu Jun 03 04:31:21 2010ribasushi [...] leporine.io - Correspondence added
I don't think "fixing" the parser for such statements is appropriate.
All sqlt can do is ignore them, since it does not have a concept of
multiple schemas. If we do in fact ignore the ALTERs, then you will end
up with a merged version of all tables from all domains. Is this desirable?
Thu Jun 03 04:31:24 2010The RT System itself - Status changed from 'new' to 'open'
Wed Nov 17 06:21:00 2010ribasushi [...] leporine.io - Correspondence added
No reply from ticket author, stalling indefinitely.
Wed Nov 17 06:21:01 2010ribasushi [...] leporine.io - Status changed from 'open' to 'stalled'
Sat Dec 24 02:56:48 2011ribasushi [...] leporine.io - Correspondence added
Copied fro GitHub
=====================
lazzarello opened this issue March 15, 2011
the PostgreSQL parser does not read default --schema-only output from
pg_dump. It fails in my dump at line two which is an ALTER SCHEMA ...
statement. Removing the statement succeeds.
Sat Dec 24 02:56:49 2011The RT System itself - Status changed from 'stalled' to 'open'