zencart_brian=# \i add_fkeys.sql
ALTER TABLE
ALTER TABLE
ALTER TABLE
psql:add_fkeys.sql:11: ERROR:  there is no unique constraint matching given keys for referenced table "products_options"
psql:add_fkeys.sql:14: ERROR:  there is no unique constraint matching given keys for referenced table "products_options_values"
ALTER TABLE
ALTER TABLE
ALTER TABLE
psql:add_fkeys.sql:26: ERROR:  there is no unique constraint matching given keys for referenced table "orders_status"
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
psql:add_fkeys.sql:137: WARNING:  foreign key constraint "customers_basket_fk_2" will require costly sequential scans
DETAIL:  Key columns "products_id" and "products_id" are of different types: character varying and integer.
ALTER TABLE
ALTER TABLE
psql:add_fkeys.sql:143: WARNING:  foreign key constraint "customers_basket_attributes_fk_2" will require costly sequential scans
DETAIL:  Key columns "products_id" and "products_id" are of different types: character varying and integer.
ALTER TABLE
psql:add_fkeys.sql:146: ERROR:  there is no unique constraint matching given keys for referenced table "products_options"
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
psql:add_fkeys.sql:164: ERROR:  there is no unique constraint matching given keys for referenced table "products_options"
psql:add_fkeys.sql:167: ERROR:  there is no unique constraint matching given keys for referenced table "products_options_values"
zencart_brian=#