Re: oid not "UNIQUE" for use as FOREIGN KEY?
От | Ernesto Baschny |
---|---|
Тема | Re: oid not "UNIQUE" for use as FOREIGN KEY? |
Дата | |
Msg-id | 3BD5FCEE.10741.3741D32@localhost обсуждение исходный текст |
Ответ на | Re: oid not "UNIQUE" for use as FOREIGN KEY? (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Ответы |
Re: oid not "UNIQUE" for use as FOREIGN KEY?
|
Список | pgsql-general |
On 23 Oct 2001 at 9:18, Stephan Szabo wrote: > > (...) > > As of yesterday, I think this is a bug, because you can now create a > > unique constraint on the OID column ... but I see it still doesn't work: > The yes was to it being a bug. I've always treated it as such since you > could make the "constraint" by making the index manually, just a low > priority one since such uses of oid should be discouraged anyway. :) Thats interesting, as I thought that would be an "elegant" way of doing that. I've got the idea from Bruce Momjian's book, here: http://www.ca.postgresql.org/docs/aw_pgsql_book/node71.html Should I instead stick to separate INTEGER PRIMARY KEY _id fields instead of using the OID's for it? What use would one want to make of an OID then? -- Ernesto Baschny <ernst@baschny.de> http://www.baschny.de - PGP Key: http://www.baschny.de/pgp.txt Sao Paulo/Brasil - Stuttgart/Germany Ernst@IRCnet - ICQ# 2955403
В списке pgsql-general по дате отправления: