On Wed, 24 May 2006 18:15:01 +0200 Christoph Zwerschke <[EMAIL PROTECTED]> 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 _______________________________________________ PyGreSQL mailing list [email protected] http://mailman.vex.net/mailman/listinfo/pygresql
