Re: Indices for foreign keys - Mailing list pgsql-general

From Denis Gasparin
Subject Re: Indices for foreign keys
Date
Msg-id 1012810791.2405.2.camel@edspctec12
Whole thread Raw
In response to Indices for foreign keys  ("Jeff Martin" <jeff@dgjc.org>)
List pgsql-general
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
>
>
>



pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: Distributing index's/tables/logs/etc.
Next
From: "Arsalan Zaidi"
Date:
Subject: Re: Distributing index's/tables/logs/etc.