A simple question

From: juanmime(at)ono(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: A simple question
Date: 2005-03-16 15:56:33
Message-ID: 422CFD5E0000774A@resmta04.ono.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,
I wonder if postgres autocreates an index on foreign or primary key fields.

For example:

create table t1 (
f1 integer,
f2 varchar,
primary key (f1));

create table t2 (
f1 integer,
f2 integer,
primary key (f1),
foreign key (f2) references t1(f1)
);

In this sample, "t1" has a primary key, and "t2" both (primary and foreign
keys).
Does postgres create each indexes for the primary key of "t1" and "t2" ?

and indexes for "f2" field in "t2" ?

I expleain, there are several DBMS where autocreates these indexes for you,
and others that shows you an alert, for example, if you don't create an unique
index for the primary key.

Thanks.

Browse pgsql-admin by date

  From Date Subject
Next Message Marcin Giedz 2005-03-16 16:00:59 Re: Performance problem...
Previous Message John DeSoi 2005-03-16 15:11:38 Re: FYI: Interview with Josh Berkus at Mad Penguin