Hi,
Le Friday 02 November 2007 21:08:24 Tom Lane, vous avez écrit :
> No, foreign-key triggers always have names too, and they don't look like
> that (they look like RI_ConstraintTrigger_nnn). I cannot find anyplace
> in PG that supplies "<unnamed>" as a default name for a trigger, either.
> So there's something weird about your schema, and we really need to
> see a test case ...
I've had some restore problems with "<unnamed>" triggers on a 8.1 database. It
contained some de-activated triggers dating from pre-7.3 era, and I finally
managed to clean out the schema with the adddepend contrib
utility.http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/adddepend/Attic/
After running this, I had no more problems related to unnamed triggers, but I
can't remember the specifics of the errors I had. For adddepend to run, some
data were to be removed, too (disabled constraint triggers made possible to
insert them at some point in the past).
Sorry for the imprecision of the post, hope this helps,
--
dim