Bug #55361 for SQL-Translator: PostgreSQL parser barfs on "ALTER DOMAIN"

Mon Mar 08 21:51:23 2010 nick.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 2010 ribasushi [...] 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 2010 The RT System itself - Status changed from 'new' to 'open'

Wed Nov 17 06:21:00 2010 ribasushi [...] leporine.io - Correspondence added

No reply from ticket author, stalling indefinitely.

Wed Nov 17 06:21:01 2010 ribasushi [...] leporine.io - Status changed from 'open' to 'stalled'

Sat Dec 24 02:56:48 2011 ribasushi [...] 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 2011 The RT System itself - Status changed from 'stalled' to 'open'