Skip Menu |
 

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

Report information
The Basics
Id: 44251
Status: new
Priority: 0/
Queue: SQL-Translator

People
Owner: Nobody in particular
Requestors: abromfie [...] gmail.com
Cc:
AdminCc:

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



Subject: problem parsing postgres schema
MIME-Version: 1.0
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Charset: utf8
X-RT-Original-Encoding: utf-8
Content-Type: multipart/mixed; boundary="----------=_1237313622-25907-148"
Content-Length: 0
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: binary
Content-Length: 1216
Download (untitled) / with headers
text/plain 1.1k
While trying to convert the attached file to GraphViz, I encountered a couple of problems: 1. Functions whose bodies are inside dollar quotes: $$ ... $$ did not parse correctly. I don't know whether this problem is more general. 2. I got lots of errors like these: "translate: Error with parser 'SQL::Translator::Parser::PostgreSQL': Couldn't create table 'net_addresses': Can't create table: "" exists at /usr/share/perl5/SQL/Translator/Parser/PostgreSQL.pm line 998." I was able to get around them only by renaming every table so that no table's name was a prefix of another's, and deleting a large number of indexes. The program I ran is below; it's taken straight out of the documentation. I'm running Debian-maintained Perl 5.10 on lenny. Thanks! ~ Aleks #!/usr/bin/perl use strict; use warnings; use SQL::Translator; my $trans = new SQL::Translator( from => 'PostgreSQL', to => 'GraphViz', filename => '/home/aleks/pro/udb/schema/schema.sql2', producer_args => { out_file => '/home/aleks/pro/udb/schema/schema.png', add_color => 1, show_constraints => 1, show_datatypes => 1, show_sizes => 1 } ) or die SQL::Translator->error; $trans->translate or die $trans->error;
Subject: schema.sql
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="----------=_1237313622-25907-147"
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Charset: utf8
Content-Length: 0
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: iso-8859-1
Content-Length: 0
Content-Type: text/x-sql; name="schema.sql"
Content-Disposition: inline; filename="schema.sql"
Content-Transfer-Encoding: binary
Content-Length: 18882
Download schema.sql
text/x-sql 18.4k

Message body is not shown because it is too large.



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

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.