Marius Kjeldahl wrote:
I've got an application where I do the following:
It seems Postgres gets confused with my usage of a variable with colon
in it, and the default quoting being done on strings somewhere in
DBD::Pg or DBIx::Class doesn't seem to pursuade Postgres from
interpreting the string with the colon in as a special "variable" field
(or whatever, I haven't looked to deep into this functionality of
Postgres).
This doesn't have anything to do with PostgreSQL. This appears to be a
driver issue.
instead, hoping that manually calling quote from the dbh driver from
DBD::Pg would take care of it, but no such luck.
The error message being generated by Catalyst/DBIx::Class is:
Cannot mix placeholder styles ":foo" and "?"
Does anybody have an idea how I can pursuade Postgres into accepting
this as just a simple string and that Postgres shouldn't try to
interpret anything in it?
Yeah, quote the string. You can't submit an unquoted string to PostgreSQL.
Sincerely,
Joshua D. Drake
_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
