Skip Menu |

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 55361
Status: open
Priority: 0/
Queue: SQL-Translator

People
Owner: Nobody in particular
Requestors: nick.phillips [...] otago.ac.nz
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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
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?
No reply from ticket author, stalling indefinitely.
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.