AW: [Dbix-class] Re: Postgresql delimiter problem

[Mario Minati]

Thank you!

That solves it - no idea why it happens as the table has been auto created through DBIX::Class::Journal !?


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.minati at minati.de
WWW: www.minati.de
 
Ablage: 
WV: 

-----Ursprüngliche Nachricht-----
Von: Dagfinn Ilmari Mannsåker [mailto:ilmari at ilmari.org] 
Gesendet: Sonntag, 26. Mai 2013 21:36
An: dbix-class at lists.scsys.co.uk
Betreff: [Dbix-class] Re: Postgresql delimiter problem

Mario Minati <Mario.Minati at minati.de> writes:

> Hello,
>
> I've an interesting problem with delimiters with Postgresql:
[snip]
> 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".

Identifiers are case sensitive in PostgreSQL, but unquoted ones are folded to lower case. This means that if you didn't quote name of the column when you created the table, it will have been created as "id", but the query uses "ID", which is not the same name.

> Any ides what switch in postgresql could be the one?

There is no switch in PostgreSQL, you need to make sure your casing and quoting is consistent between creating and using the scheem.

--
"I use RMS as a guide in the same way that a boat captain would use  a lighthouse.  It's good to know where it is, but you generally  don't want to find yourself in the same spot." - Tollef Fog Heen


_______________________________________________
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