|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.