Re: removing duplicated constraints

On Sun, 3 Mar 2002, Dan Langille wrote:

> On 2 Mar 2002 at 23:42, Stephan Szabo wrote:
>
> >
> > > I found the list of duplicate constraints by eyeballing the files I
> > > created using the methods mentioned in previous post (mainly grep and
> > > sort). Then I would search in the original dump file for the the CREATE
> > > CONSTRAINT statement. Using the name found there
> > > (RI_ConstraintTrigger_998199), I did this:
> > >
> > > drop TRIGGER "RI_ConstraintTrigger_998189" on categories;
> > >
> > > Making sense?
> >
> > Well, I'm not sure that you're guaranteed to get the same trigger names
> > after the restore as the ones in the dump file comments. You may have to
> > look in the system table for the actual current trigger name for the
> > triggers with those arguments.
>
> There was no restore. I did the dump in order to find the duplicates.
> Then used that information to find and remove them.

Then yes, that's all you should need to do.