Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 28 Aug 2007 23:00:35 -0700
> 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
- References:
- Creating indices on foreign keys
- From: Sanjay
- Creating indices on foreign keys
- Prev by Date: Re: Can postgresql support chinese word?
- Next by Date: Re: PostgreSQL vs Firebird feature comparison finished
- Previous by thread: Creating indices on foreign keys
- Next by thread: ERROR: table row type and query-specified row type do not match
- Indexes: