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.min...@minati.de WWW: www.minati.de Ablage: WV: -----Ursprüngliche Nachricht----- Von: Dagfinn Ilmari Mannsåker [mailto:ilm...@ilmari.org] Gesendet: Sonntag, 26. Mai 2013 21:36 An: dbix-class@lists.scsys.co.uk Betreff: [Dbix-class] Re: Postgresql delimiter problem Mario Minati <mario.min...@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 _______________________________________________ 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
