[Tickets #11479] all-number 'object_name' in 'rampage_objects' not quoted correctly

[bugs at horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: http://bugs.horde.org/ticket/11479
------------------------------------------------------------------------------
  Ticket           | 11479
  Erstellt Von     | piper at hrz.uni-marburg.de
  Zusammenfassung  | all-number 'object_name' in 'rampage_objects' not quoted
                   | correctly
  Warteschlange    | Horde Base
  Version          | 4.0.15
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 3. High
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


piper at hrz.uni-marburg.de (2012-10-09 10:39) hat geschrieben:

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