Home > mailing lists

Re: Creating indices on foreign keys - Mailing list pgsql-general

From	Sanjay
Subject	Re: Creating indices on foreign keys
Date	August 29, 2007 23:05:36
Msg-id	1188367235.298206.253720@19g2000hsx.googlegroups.com Whole thread Raw
In response to	Creating indices on foreign keys (Sanjay <skpatel20@gmail.com>)
List	pgsql-general

Tree view

> 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

pgsql-general by date:

From: "Andrus"
Date: 29 August 2007, 23:05:33
Subject: Re: Removing pollution from log files

From: pere roca
Date: 29 August 2007, 23:05:37
Subject: counting columns

Re: Creating indices on foreign keys - Mailing list pgsql-general

Previous

Next