Re: oid's in views.

From: "Aasmund Midttun Godal" <aasmund(at)godal(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: oid's in views.
Date: 2001-10-20 11:15:48
Message-ID: 20011020111548.697.qmail@ns.krot.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

No, many of the tables have primary keys already, serial, single key or several keys. I don't want to 'serialize' every table, because it does not make sense.

Oid's however are very usefull as I can use them as a primary key on any table.

Regards,

Aasmund.

On Fri, 19 Oct 2001 15:38:16 -0700, "Josh Berkus" <josh(at)agliodbs(dot)com> wrote:
> Aasmund,
>
>
> You'd still be better off defining your own SERIAL columns and/or
> primary keys and using those. Some Trigger types require referencing
> the OID, but that's about it.
>
> -Josh
>
> ______AGLIO DATABASE SOLUTIONS___________________________
> Josh Berkus
> Complete information technology josh(at)agliodbs(dot)com
> and data management solutions (415) 565-7293
> for law firms, small businesses fax 621-2533
> and non-profit organizations. San Francisco

Aasmund Midttun Godal

aasmund(at)godal(dot)com - http://www.godal.com/
+47 40 45 20 46

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Dinesh Parikh 2001-10-20 13:35:26 Query On Case structure
Previous Message Tom Lane 2001-10-20 03:51:37 Re: Table Constraints with NULL values