Re: dropping constraints

You probably need to make sure to double quote the tgname in your drops.

On Thu, 7 Jun 2001, Linh Luong wrote:

> Hi,
>
> Is there to drop a constraint when you add it separately with an alter
> statement.
>
> alter table failuretypecategory1 add constraint fk_failuretypecategory1
> FOREIGN KEY (failurecategory1id)
> REFERENCES failurecategory1 (id) ON UPDATE CASCADE ON DELETE CASCADE;
>
> I tried
> drop trigger <tgconstrname> on failurecategory1
> and
> drop trigger <tgconstrname> on failuretypecategory1
>
> and also
>
> drop trigger <tgname> on failurecategory1
> and
> drop trigger <tgname> on failuretypecategory1
>
>
> But it kept saying
> ERROR: DropTrigger: there is no trigger <tgname>/<tgconstrname> on
> relation failuretypecategory1
>
> What am I doing wrong.
>
> I tried dropping the table also and when I tried to delete from a table
> that it referenced above it gave the error that the table I just drop
> doesn't exist. Obviously because I just removed it but the constraint
> it still there..