[PyGreSQL] Composite primary keys - again

[D'Arcy J.M. Cain]

On Wed, 24 May 2006 18:15:01 +0200
Christoph Zwerschke <cito at online.de> wrote:
> OIDs are another issue: In PG 8.0 they are optional, and in 8.1 they are 
> not even created by default anymore, but the pg module is using them a 
> lot. Any ideas how to deal with that problem?

I always add "SET DEFAULT_WITH_OIDS=ON" at the start of every schema
definition file.  I was thinking that we should probably change it to
use the primary key if available (and perhaps only if not complex) and
fall back to OID only if we can't find one.  That might even speed up
applications because the primary key is always indexed but the OID
isn't unless you explicitely create one.  That's important because the
insert always does a get afterwards in order to retrieve all side
effected fields from the new entry.

-- 
D'Arcy J.M. Cain
PyGreSQL Development Group
http://www.PyGreSQL.org