Re: oid's in views.

Поиск
Список
Период
Сортировка
От Aasmund Midttun Godal
Тема Re: oid's in views.
Дата
Msg-id 20011019191030.2126.qmail@ns.krot.org
обсуждение исходный текст
Ответ на Re: oid's in views.  ("Josh Berkus" <josh@agliodbs.com>)
Ответы Re: oid's in views.  ("Josh Berkus" <josh@agliodbs.com>)
Список pgsql-sql
On Fri, 19 Oct 2001 08:07:50 -0700, "Josh Berkus" <josh@agliodbs.com> wrote:
> Aasmund,
> 
> 
> I believe the *official* reccommendation now is that you leave the OIDs
> to the system, and create your own SERIAL values for row identification.
> There are *lots* of problems with using OIDs as an index, and you've
> just found one more!
> 
> -Josh
I don't use them in indexes foreign keys etc., however they are very usefull when your application tries to edit/update
individualrows, as the oid is like a universal primary key.
 
> 
> 
> ______AGLIO DATABASE SOLUTIONS___________________________
>                                        Josh Berkus
>   Complete information technology      josh@agliodbs.com
>    and data management solutions       (415) 565-7293
>   for law firms, small businesses        fax 621-2533
>     and non-profit organizations.      San Francisco
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html

Aasmund Midttun Godal

aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46


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

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: system maintained keys
Следующее
От: Jason Earl
Дата:
Сообщение: Re: system maintained keys