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
>