Re: using OID as primary key

Поиск
Список
Период
Сортировка
От JanWieck@t-online.de (Jan Wieck)
Тема Re: using OID as primary key
Дата
Msg-id 200007211157.NAA04499@hot.jw.home
обсуждение исходный текст
Ответ на using OID as primary key  (Markus Wagner <wagner@imsd.uni-mainz.de>)
Ответы Re: using OID as primary key  (darcy@druid.net (D'Arcy J.M. Cain))
Список pgsql-sql
Markus Wagner wrote:
> Hi,
>
> are there any disadvantages of using OID as the primary key for any
> table?
> What about referencing external tuples using their OIDs?
>
> e. g.:
> CREATE TABLE thistable
> ...
> field NUMERIC REFERENCES OtherTable (oid)
>
> Which data type should I use to reference OIDs?
>
> Will I run into problems later if I do my things this way?
   Currently OID is not supported for references. Has to do with   some checks done in the RI  triggers,  using  SPI
functions.  We're thinking about a solution...
 


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #




В списке pgsql-sql по дате отправления:

Предыдущее
От: Markus Wagner
Дата:
Сообщение: using OID as primary key
Следующее
От: darcy@druid.net (D'Arcy J.M. Cain)
Дата:
Сообщение: Re: using OID as primary key