[dev] Ansel and Postgres db

[Jos W van der Woude]

Hi,

Yesterday I installed Horde from cvs.
I am using a postgres db.

I am running into a problem with the ansel.sql script.

The script uses type blob, which pgsql does not have. I have run into  
this before and changed type to bytea.

This generates an error on the following line:
CREATE INDEX ansel_faces_index_index_part_idx ON ansel_faces_index  
(index_part (30));

psql:ansel.sql:48: ERROR:  function index_part(integer) does not exist
LINE 1: ..._faces_index_index_part_idx ON ansel_faces_index (index_part...
                                                              ^
HINT:  No function matches the given name and argument types. You  
might need to add explicit type casts.

So I added an explicit typecast, like ...

CREATE INDEX ansel_faces_index_index_part_idx ON ansel_faces_index  
(index_part (CAST (30 AS BYTEA)));

psql:ansel.sql:48: ERROR:  cannot cast type integer to bytea
LINE 1: ..._idx ON ansel_faces_index (index_part (CAST (30 AS BYTEA)));
                                                               ^
At this point I am stuck.

Any ideas?

Jos
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: PGP Digital Signature
URL: <http://lists.horde.org/archives/dev/attachments/20080912/318926e8/attachment.bin>