Hi,

I'd like to use DBIx::Recordset::DBSeq for the sequencing of generic
primary keys in a PostgreSQL (Pg) database. But I encountered two
problems:

1. DBSeq uses "LOCK TABLE xy WRITE" to get a write lock. With Pg, this
   doesn't work, because the SQL command has another syntax there --
   Pg doesn't understand the "WRITE" part. Is there an easy way to
   achieve database compatibility? Or should I simply derive my own
   DBSeqPg class?

2. How can I pass the DBI handle of a DBIx::Database onto
   DBIx::Recordset::DBSeq via the "!SeqClass" parameter of a
   DBIx::Recordset?

TIA,

        Jochen

-- 
----------------------------------------------------------------
 *Jochen Lillich*, Consultant/Trainer @ /TeamLinux GbR/
 Rheinstr. 26, 76676 Graben-Neudorf, Germany
 Tel. +49 7255 76784-12, Fax -50, http://www.teamlinux.de
----------------------------------------------------------------

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to