blue_cowdawg has asked for the wisdom of the Perl Monks concerning the following question:
I have a rather large schema that I'm trying to use SQL::Translator (sqlt) to create a diagram of with. When I run the sqlt command
I get the rather annoying error message:sqlt -f PostgreSQL -t Diagram bcdc-schema.sql
Anybody else run into this? Thoughts?Error: translate: Error with parser 'SQL::Translator::Parser::PostgreS +QL': Couldn't create table 'state': Can't create table: "" exists at +/usr/lib/perl5/site_perl/5.8.5/SQL/Translator/Parser/PostgreSQL.pm li +ne 934.
The table in question is defined as:
CREATE TABLE state ( state_id serial NOT NULL, abbr character varying(2) DEFAULT ''::character varying NOT NULL, name character varying(40) DEFAULT ''::character varying NOT NULL );
Is "state" a reserved word in SQL::Translator?
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Odd issue with sqlt PostgreSQL translator.
by merlyn (Sage) on Feb 01, 2007 at 17:28 UTC | |
by jasonk (Parson) on Feb 03, 2007 at 02:42 UTC | |
by blue_cowdawg (Monsignor) on Feb 01, 2007 at 21:09 UTC |