Re: [JDBC] [PERFORM] is a good practice to create an index on the

Поиск
Список
Период
Сортировка
Искать
От
Christopher Kings-Lynne
Тема
Re: [JDBC] [PERFORM] is a good practice to create an index on the
Дата
Msg-id
408F0944.5060608@familyhealth.com.au
Ответ на
Список
Дерево обсуждения
is a good practice to create an index on the oid? Edoardo Ceccarelli <eddy@axa.it>
Re: [JDBC] is a good practice to create an index on the oid? Dave Cramer <pg@fastcrypt.com>
Re: [PERFORM] is a good practice to create an index on the oid? Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: [JDBC] [PERFORM] is a good practice to create an index on the Dave Cramer <pg@fastcrypt.com>
Re: [JDBC] [PERFORM] is a good practice to create an index on the Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: [JDBC] [PERFORM] is a good practice to create an index on the Dave Cramer <pg@fastcrypt.com>
Re: [JDBC] [PERFORM] is a good practice to create an index on the Edoardo Ceccarelli <eddy@axa.it>
Re: [JDBC] [PERFORM] is a good practice to create an index on the Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: [JDBC] [PERFORM] is a good practice to create an index on the Edoardo Ceccarelli <eddy@axa.it>
Re: [JDBC] [PERFORM] is a good practice to create an index on the Bruno Wolff III <bruno@wolff.to>
Re: [JDBC] [PERFORM] is a good practice to create an index on the Christopher Kings-Lynne <chriskl@familyhealth.com.au>
> 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 по дате отправления
От: jseymour@LinxNet.com (Jim Seymour)
Дата:
Сообщение: Re: Recover data
От: Edoardo Ceccarelli
Дата:
FAQ