pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Linh Luong <linh.luong@computalog.com>
To: pgsql-sql@postgresql.org
Subject: dropping constraints
Date: Thu, 07 Jun 2001 09:32:04 -0600
Message-ID: <3B1F9E74.47067EEF@computalog.com> (raw)

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.. 

Thanks

-- 
Linh Luong



view thread (2+ messages)  latest in thread

Message-ID: <3B1F9E74.47067EEF@computalog.com>
Permalink:  ../3B1F9E74.47067EEF@computalog.com/
Also on:    postgresql.org/message-id/3B1F9E74.47067EEF@computalog.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: linh.luong@computalog.com
  Subject: Re: dropping constraints
  In-Reply-To: <3B1F9E74.47067EEF@computalog.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox