#3 Warnings generated by PostgreSQL foreign key constraints.

[Jonathan Crabtree]

49 of the foreign key constraint statements in create_cm_indices.postgresql.ddl generate warnings of the following variety (in PostreSQL 8.1.11):

ALTER TABLE stockcollectionprop ADD CONSTRAINT fk_stockcollectionprop02 FOREIGN KEY (type_id) REFERENCES cvterm (cvterm_id);
psql:/expurgated/docs/ddls/postgresql/create_indexes.postgresql.ddl:521: WARNING: foreign key constraint "fk_stockcollectionprop02" will require costly sequential scans
DETAIL: Key columns "type_id" and "cvterm_id" are of different types: numeric and integer.

The list of the 49 affected constraints is attached.

[Jonathan Crabtree]

List of 49 FK constraints that generate warnings.