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?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Case problem
Следующее
От: "Aasmund Midttun Godal"
Дата:
Сообщение: Re: Record