| Subject: | Pg Handle relies on OIDs |
The Insert method in DBIx::SearchBuilder::Handle::Pg does a select for
the oid of the row that was just inserted. PostgreSQL 8.1 has oid's
turned off by default on userspace tables, which will cause this method
to break.
(You could optionally turn them off in 8.0, as well)
An additional side effect of this behavior is that selecting for the OID
causes a full table scan, and this can be quite consuming in large RT
installations.
An implementation that uses currval() to get the latest row of the
sequence may be one possible solution, assuming we are always hitting
tables with sequences for primary key's.
There will likely be a patch to follow, since we're having trouble with
this in our current install.