[Rt-devel] Postgres and RTx extension

[Manuel SUBREDU]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

I recently written a extention for RT and I have a problem. How should I
create the schema for Postgresql ? It seems that pgsql does not care
about sensitivity in names and I end up in situations where I have a
table named "Customers" and RT failes to insert a record saying that:

[Tue Jan  8 19:01:23 2008] [warning]: DBD::Pg::st execute failed: ERROR:
 relation "customers" does not exist
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:505)
[Tue Jan  8 19:01:23 2008] [warning]: RT::Handle=HASH(0x91bfc6c)
couldn't execute the query 'INSERT INTO Customers (Details, Created,
Creator, Email, Name) VALUES (?, ?, ?, ?, ?)' at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 518


 The create statement for Pg looks like this:

CREATE TABLE "Customers" (
    id integer DEFAULT nextval('seq_customers_idx'::regclass) NOT NULL,
    "Name" character varying(128) NOT NULL,
    "Email" character varying(128) NOT NULL,
    "Details" text,
    "Creator" integer NOT NULL,
    "Created" timestamp without time zone
);

What is wrong here ?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHg8xAjGXbUSvc3AsRAjPgAJ4i1J8uTtAxNYyIJ7Wr0wfyry7wVwCdHU9N
wYZlDjc4bxGMQKAmfdPcj2k=
=0T+K
-----END PGP SIGNATURE-----