[Dbix-class] issue with deploy() and pgsql's timestamp with time zoneUser-Agent: SquirrelMail/1.5.2 [SVN]

Guillaume Chambriat gc at riseup.net
Sat May 23 17:32:21 GMT 2009


I've a PostgreSQL table:

create table date_fields (
    id          serial primary key,
    message     integer references messages(id)
                on delete cascade,
    value       timestamp with time zone

And the corresponding schema class, generated by
DBIx::Class::Schema::Loader, has the following code for the "value"
column :

    data_type => "timestamp with time zone",
    default_value => undef,
    is_nullable => 1,
    size => 8,

When I try to deploy this schema to an empty DB, I get the following
error message (roughly translated from French into English):

DBIx::Class::Schema::deploy(): DBI Exception: DBD::Pg::db do failed:
ERROR:  syntax error near " ( "
LINE 5:   "value" timestamp with time zone(6),
                                          ^ at ./script/myapp_hub_spawn_db.pl line 45
 (running "
CREATE TABLE "date_fields" (
  "id" serial NOT NULL,
  "message" smallint,
  "value" timestamp with time zone(6),
  PRIMARY KEY ("id")
)") at /usr/local/share/perl/5.10.0/DBIx/Class/Storage/DBI.pm line
1811, <STDIN> line 4.

The same SQL code, copied in a psql shell, triggers the same
error message. Removing '(6)' obviously fixes it.

Any idea why IdontKnowWhichModule (SQL::Translator, another one?) adds
'(6)' to the generated SQL code?

  Guillaume Chambriat <gc at riseup.net>

More information about the DBIx-Class mailing list