Skip Menu |
 

This queue is for tickets about the DBIx-SearchBuilder CPAN distribution.

Report information
The Basics
Id: 15787
Status: resolved
Priority: 0/
Queue: DBIx-SearchBuilder

People
Owner: Nobody in particular
Requestors: holoway [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: Pg Handle relies on OIDs
Download (untitled) / with headers
text/plain 716b
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.
Date: Thu, 8 Dec 2005 16:00:16 -0500
From: jesse <jesse [...] fsck.com>
To: via RT <bug-DBIx-SearchBuilder [...] rt.cpan.org>
CC: undisclosed-recipients: ;
Subject: Re: [cpan #15787] Pg Handle relies on OIDs
RT-Send-Cc:
Can you try out the just-released 1.37_01 which should fix this?


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.