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>

Download (untitled) / with headers
text/plain 356b

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

Download (untitled) / with headers
text/plain 285b

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

Download (untitled) / with headers
text/plain 51b

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

Download (untitled) / with headers
text/plain 269b

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'