[Tickets #9725] vCard (3.0) that contains a photo can't be imported when using postgres

[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/9725
------------------------------------------------------------------------------
  Ticket           | 9725
  Erstellt Von     | gsnerf at gsnerf.de
  Zusammenfassung  | vCard (3.0) that contains a photo can't be imported when
                   | using postgres
  Warteschlange    | Horde Groupware Webmail Edition
  Version          | 1.2.9
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 2. Medium
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


gsnerf at gsnerf.de (2011-03-27 13:32) hat geschrieben:

When importing a vcard turba checks if the contained contacts are  
already present in the database so it does not double contacts on  
import. In the sql select statement of this check there is an ILIKE  
comparison on the field 'object_photo' which is of type bytea.
This is not valid in postgres and leads to the following error:

ERROR:  operator does not exist: bytea ~~* unknown

See the following entry in the postgres mailing list on this error:  
http://archives.postgresql.org/pgsql-admin/2009-09/msg00041.php

I suggest to either correctly cast the entry into something that can  
be compared, or simply remove the check for the photo as I don't think  
this is a check that has any value to the task of finding double  
entries.

PS: sorry if this is already reported and fixed in the turba query, I  
couldn't find a similar entry