On 7/12/05, Christian Schoepplein
I tryed it now on my system with an actual OTRS from the cvs head, postgresql 8 on a debian system. I wasn't able to reproduce the problems with abostrophes in the subject or other fields.
I think that a recent version of DBD::Pg will solve all these problems. I use 1.42-2 (libdbd-pg-perl 1.42-2 on debian unstable). It would be nice, if someone else could test this with a newer version of DBD::Pg too and post if it was successful or not.
I'm using a more recent version of DBD::Pg than you are. I've updated the bug report with the correct version. From my FreeBSD system: % pkg_info -xI Pg p5-DBD-Pg-1.43 Provides access to PostgreSQL databases through the DBI However, I'm using PostgreSQL v7.4.8, not v8. I'll have to investigate what impacts there'd be to upgrading to v8 for testing here - OTRS is not the only application using that PostgreSQL instance. Do you have any way to test with v7.x? Thanks, Bryan