Re: [JDBC] [PERFORM] is a good practice to create an index on the - Mailing list pgsql-admin

From Christopher Kings-Lynne
Subject Re: [JDBC] [PERFORM] is a good practice to create an index on the
Date
Msg-id 408F0944.5060608@familyhealth.com.au
Whole thread Raw
In response to Re: [JDBC] [PERFORM] is a good practice to create an index on the  (Edoardo Ceccarelli <eddy@axa.it>)
Responses Re: [JDBC] [PERFORM] is a good practice to create an index on the
List pgsql-admin
> I am going to use them as primary key of the table, so I'll surely need
> them unique :)

Eduoardo, I REALLY suggest you don't use them at all.  You should make a
primary key like this:

CREATE TABLE blah (
   id SERIAL PRIMARY KEY,
   ...
);

Also note that by default, OIDs are NOT dumped by pg_dump.  You will
need to add extra switches to your pg_dump backup to ensure that they are.

Chris


pgsql-admin by date:

Previous
From: jseymour@LinxNet.com (Jim Seymour)
Date:
Subject: Re: Recover data
Next
From: Edoardo Ceccarelli
Date:
Subject: Re: [JDBC] [PERFORM] is a good practice to create an index on the