Re: removing duplicated constraints

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.

cheers
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples