Subject: | Tables with 'time zone' attributes are not recognised |
For PostgreSQL the following is legal SQL:
create table Vessel (
...
time_last_passage timestamp(0) with time zone,
...
} without oids
Yet - with trying to run
sqlt-diagram --db=PostgreSQL schema.sql > schema.png
the resulting schema.png will not contain the Vessel class; or the following message is shown after the cmd line:
Error: translate: Error with parser 'SQL::Translator::Parser::PostgreSQL': Could
n't create table 'Vessel': No table name at /usr/lib/perl5/site_perl/5.8.0/SQL/T
ranslator/Parser/PostgreSQL.pm line 869.
If the time zone attributes are commented out (--) the table is shown nicely in the png file.
Thanks for keeping up the good work!
/Thomas.