Postgres Pro
Downloads
Home   >   mailing lists

Thread: Indices for foreign keys

Indices for foreign keys

From
"Jeff Martin"
Date:
Are indices automatically created for foreign keys?
 
Thanks for any help,
 
Jeff

Jeff Martin
704 Torrey Lane, Apartment D
Boalsburg, PA 16827
H814-466-7791
jeff@dgjc.org
www.dgjc.org

 

Re: Indices for foreign keys

From
Denis Gasparin
Date:
I think no.
    The foreign key constraint implies a trigger that enforces the
relationship between the tables but no index is created. You'll have to
create it yourself.

Bye

--
Ing. Denis Gasparin: denis@edistar.com
---------------------------
Programmer & System Administrator - Edistar srl


Il sab, 2002-02-02 alle 23:04, Jeff Martin ha scritto:
> Are indices automatically created for foreign keys?
>
> Thanks for any help,
>
> Jeff
> Jeff Martin
> 704 Torrey Lane, Apartment D
> Boalsburg, PA 16827
> H814-466-7791
> jeff@dgjc.org
> www.dgjc.org
>
>
>

Re: Indices for foreign keys

From
Vivek Khera
Date:
>>>>> "JM" == Jeff Martin <jeff@dgjc.org> writes:


JM> Are indices automatically created for foreign keys?

JM> Thanks for any help,

Empirical evidence suggests no; if it is not documented, submit a
change request for the docs.

Also, don't post HTML.  Thanks.