Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Creating indices on foreign keys
- From: Sanjay <skpatel20(at)gmail(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Creating indices on foreign keys
- Date: Tue, 28 Aug 2007 00:08:18 -0700
Hi All, 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? thanks Sanjay
- Follow-Ups:
- Re: Creating indices on foreign keys
- From: Sanjay
- Re: Creating indices on foreign keys
- Prev by Date: Re: Tables dissapearing
- Next by Date: Re: Tables dissapearing
- Previous by thread: Crashed DB and "base" WAL files
- Next by thread: Re: Creating indices on foreign keys
- Indexes: