[PERFORM] Foreign keys and partial indexes

Hello! I have a partial index (btree(col) WHERE col 0) on table2 ('col' contains alot of NULL-values). There's also a foreign key on the column pointing to the primary key of table1 (ON UPDATE CASCADE ON DELETE SET NULL). During update/delete, it seems like it cannot use the partial index

Re: [PERFORM] Foreign keys and partial indexes

Nichlas =?iso-8859-1?Q?L=F6fdahl?= [EMAIL PROTECTED] writes: I have a partial index (btree(col) WHERE col 0) on table2 ('col' contains alot of NULL-values). There's also a foreign key on the column pointing to the primary key of table1 (ON UPDATE CASCADE ON DELETE SET NULL). During