Re: maximum number of rows in table - what about oid limits?
От | Jonathan Bartlett |
---|---|
Тема | Re: maximum number of rows in table - what about oid limits? |
Дата | |
Msg-id | Pine.LNX.4.21.0106081521080.9063-100000@sdf.lonestar.org обсуждение исходный текст |
Ответ на | Re: maximum number of rows in table - what about oid limits? (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: maximum number of rows in table - what about oid limits?
|
Список | pgsql-sql |
> 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 >
В списке pgsql-sql по дате отправления: