Hi,
I created a foreign key constraint on table referral like this:
alter table referral add constraint fk_referral foreign key (handle)
references domain (handle);
create
alter table referral drop constraint fk_referral restrict;
ERROR: ALTER TABLE / DROP CONSTRAINT: fk_referral does not exist.
I am using postgres 7.2. If fk can't be dropped, what the synax: ALTER TABLE
[ ONLY ] table DROP CONSTRAINT constraint { RESTRICT | CASCADE } for in
docs? If we have to drop fk, does this mean we have to drop table and
recreate without fk? Stupid!
Anybody has an experience that droped fk succefully? Thanks!
Anna Zhang