Am 23.05.2009 um 19:32 schrieb Guillaume Chambriat:
Hi,
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 :
"value",
{
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?
This is because you defined a size on that column.
Remove size => 8 and deploy will do the right thing. I think it's both
a problem in Schema::Loader and SQL::Translator.
moritz
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
