Skip Menu |

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

Report information
The Basics
Id: 6337
Status: resolved
Priority: 0/
Queue: SQL-Translator

People
Owner: Nobody in particular
Requestors: tbs [...] navicon.dk
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 0.05
Fixed in: 0.11003



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.