Postgres Pro
Downloads
Home   >   mailing lists

Re: Shorthand for foreign key indices - Mailing list pgsql-general

From John D. Burger
Subject Re: Shorthand for foreign key indices
Date
Msg-id 0aeca0af83faf7139d447c0996bd9428@mitre.org
Whole thread Raw
In response to Shorthand for foreign key indices  (Brendan Jurd <direvus@gmail.com>)
Responses Re: Shorthand for foreign key indices  ("Jim C. Nasby" <decibel@decibel.org>)
List pgsql-general
Tree view 
> I know that it was decided a fair few releases ago to stop creating an
> implicit index for each foreign key,

By the way, I presume foreign key indices are used to check for
referential integrity on insert.  Can the query planner also use then
somehow?

Thanks.

- John D. Burger
   MITRE

pgsql-general by date:

Previous
From: Dario Lah
Date:
Subject: Re: Any experiance with PostgreSQL and SQLRelay
Next
From: "Sim Zacks"
Date:
Subject: Re: function call error