Re: Creating indices on foreign keys

From: Sanjay <skpatel20(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Creating indices on foreign keys
Date: 2007-08-29 06:00:35
Message-ID: 1188367235.298206.253720@19g2000hsx.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I think PostgreSQL does not create indexes on foreign keys of a table,
> and I have to do so explicitly. That means, wherever I am using master-
> detail table, I have to create explicit indexes on the foreign key in
> the detail table. Am I wrong?

Refering the discussion here, I assume I am correct:

http://groups.google.co.in/group/pgsql.general/browse_thread/thread/516db5b5f36c82d0

thanks
Sanjay

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2007-08-29 06:46:46 Re: PostgreSQL vs Firebird feature comparison finished
Previous Message Michael Glaesemann 2007-08-29 03:52:06 Re: Can postgresql support chinese word?