> I've been thinking it should be a compile-time option. But the protocol
> issue is going to be a problem.
The protocol issues shouldn't be a problem if you require separate
drivers. Force clients to use libpq64.so.
The reason I'm concerned about this is that there are a _lot_ of great
things you can do with OIDs if they are unique. For example, if you've
worked with Oracle Applications, they have this tacked on to the end of
all of their tables:
LAST_UPDATED_BY Int,
LAST_UPDATED_DATE Date,
...
Which could be replaced by a single table
Table UPDATE_HISTORY REFERRED_OBJECT OID, LAST_UPDATED_BY OID, LAST_UPDATED_DATE Date
which applies to all tables. You could also have a notes table for
everything -
table NOTES REFERRED_OBJECT OID, Note Text
And so on and so forth. However, with OID wrap-around, this would be
problematic.
Jon
>
> regards, tom lane
>
