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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
