Hi -
I know that the foreign key machinery will use an index on the
referring column if one exists. My question is whether it will use a
composite index? For instance:
create table allLemmaSenseMap (
wordID integer references allLemmas,
senseIDinteger references allSenses,
p
On Nov 29, 2007 10:51 AM, John Burger <[EMAIL PROTECTED]> wrote:
> Hi -
>
> I know that the foreign key machinery will use an index on the
> referring column if one exists. My question is whether it will use a
> composite index? For instance:
>
> create table allLemmaSenseMap (
>wordID in
Scott Marlowe wrote:
As a secondary question, is there any way I could have answered this
myself, using analyze, the system catalogs, etc? ANALYZE DELETE
doesn't seem to show the FK checking that must go on behind the
scenes.
You could have coded up an example to see if it worked I guess.
H
"John Burger" <[EMAIL PROTECTED]> writes:
> Scott Marlowe wrote:
>
>>> As a secondary question, is there any way I could have answered this
>>> myself, using analyze, the system catalogs, etc? ANALYZE DELETE
>>> doesn't seem to show the FK checking that must go on behind the scenes.
>>
>> You co
Gregory Stark wrote:
I guess a generalization of my question is whether the FK-
checking machinery
simply does a SELECT against the referencing column.
It does
Actually the query is (effectively, assuming your equality
operators are named
"=" and the columns match in type)
SELECT 1
F