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

Owner: Nobody in particular
Requestors: nick.phillips [...]

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 [...]
From: Nick Phillips <nick.phillips [...]>
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 / # these statements are my own, not those of the University of Otago
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?
No reply from ticket author, stalling indefinitely.
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.

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to