Re: Fw: OID

Jodi,

> How to remove them in version 7.2?

Create the table using WITHOUT OIDS.
Example.

CREATE TABLE users (
    user_id serial NOT NULL,
    user_name varchar(20) NOT NULL,
    passwd varchar(32) NOT NULL,
    CONSTRAINT pk_user_id PRIMARY KEY(user_id)
) WITHOUT OIDS;

Take Care.

Dan

----- Original Message -----
From: "Joe Conway" <mail@joeconway.com>
To: "Jodi Kanter" <jkanter@virginia.edu>
Cc: "Postgres Admin List" <pgsql-admin@postgresql.org>
Sent: Friday, August 16, 2002 16.40
Subject: Re: [ADMIN] Fw: OID


> Jodi Kanter wrote:
> > Does anyone have a comment on the email below? Is there a general
> > consensus on whether or not to use OIDs with version 7.2?
>
> <snip>
>
> >
> > Can anyone point me to some documentation on the use of OIDs? Why might
> > I need them? How to remove them in version 7.2? ..etc...
>
> I think you're best to avoid using them. They are primarily for internal
> system use. If you need an incrementing integer field, create your own
> with SERIAL, or integer field and a sequence.
>
> To create a table without oids, see:
>    http://www.postgresql.org/idocs/index.php?sql-createtable.html
>
> Joe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>