Re: [SQL] cluster index on primary key

2007-06-11 Thread Rodrigo De León
On 6/11/07, Sabin Coanda <[EMAIL PROTECTED]> wrote: I'd like to know when I create a primary key on a table, does postgres will create automatically an index on that table related to the primary key columns, or I have to create it explicitly ? From http://www.postgresql.org/docs/8.2/static/ind

[SQL] cluster index on primary key

2007-06-11 Thread Sabin Coanda
Hi there, I'd like to know when I create a primary key on a table, does postgres will create automatically an index on that table related to the primary key columns, or I have to create it explicitly ? If I have to create it explicitly, suppose I have tables with a serial primary key, or link