Tickets :: Comment on [#11479] all-number 'object_name' in 'rampage

* Your Email Address
* Spam protection	Enter the letters below: ..__.. ,\ /. \|\| \| \./ >< \| \__\|\|__\| \| / \\|___
Comment	> With horde-4.0.15 and postgresql-8.4 I get these error messages in > the postgresql-log: > > 2012-10-09 12:21:05 CEST ERROR: operator does not exist: character > varying = bigint at character 72 > 2012-10-09 12:21:05 CEST HINT: No operator matches the given name > and argument type(s). You might need to add explicit type casts. > 2012-10-09 12:21:05 CEST STATEMENT: SELECT object_id, object_name > FROM "rampage_objects" WHERE object_name IN > ('b2e8e7c2-c5eb-44bc-8321-7dd251b8d05d',5500491941,'179ceb24-8737-442b-a076-f3c9e12fda2b','e6198476-7ee2-47e2-873a-599d6d7f9843','bcd209c6-3e0b-42b6-992f-a185c77de143',6182398035,'ed3d3056-af2c-4500-8b84-6a565c6301b9','7ac3e317-7cee-4852-adca-f8520054c3b1') AND type_id = > 2 > > The object-names which contain only numbers are incorrectly not > quoted as strings and therefore recognized as bigint, in the example > this is the number 6182398035 > > Where should this be corrected? > > Thanks a lot, > Andreas > >
Attachment
Watch this ticket