Hello,
I've an interesting problem with delimiters with Postgresql:
While preparing a new production server I found that the code, which is running
fine on development server, doesn't work - probably because of Postgresql
config problem.
But I cannot remember any more if I have changed any setting while setup of dev
server.
The code:
<snip>
#!/usr/bin/env perl
use strict;
use warnings;
use feature ":5.10";
use FindBin;
use lib "$FindBin::Bin/../lib";
use glueDB::Schema;
use Config::JFDI;
my $config = Config::JFDI->new( name => 'glue' );
my $config_hash = $config->get;
my $connect_info = $config_hash->{"Model::glueDB"}{"connect_info"};
my $schema = glueDB::Schema->connect($connect_info);
my $debug = 0;
$schema->txn_do( sub {
$schema->resultset('Common::Country')->create({ name => 'TEST' });
});
<snap>
Throws on prod server (with DBIC_TRACE enabled):
BEGIN WORK
INSERT INTO "changeset" ( "set_date") VALUES ( ? ) RETURNING "ID": '2013-05-26
19:05:20'
ROLLBACK
DBI Exception: DBD::Pg::st execute failed: ERROR: column "ID" does not exist
LINE 1: ... INTO "changeset" ( "set_date") VALUES ( $1 ) RETURNING "ID"
^ [for
Statement "INSERT INTO "changeset" ( "set_date") VALUES ( ? ) RETURNING "ID""
with ParamValues: 1='2013-05-26 19:05:20'] at
/usr/local/share/perl/5.14.2/DBIx/Class/Schema.pm line 1080.
The problem is on "ID".
Any ides what switch in postgresql could be the one?
Best greets,
Mario Minati
--
MINATI
Planungsbüro für Haustechnik
Dörenwaldstraße 6a
D-32760 Detmold
Germany
Tel: +49 / 5231 / 4580-100
Fax: +49 / 5231 / 4580-118
E-Mail: mario.min...@minati.de
WWW: www.minati.de
Ablage:
WV:
_______________________________________________
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/dbix-class@lists.scsys.co.uk
