Conditional trigger missing from pg_dump

Josh Berkus <josh@agliodbs.com> writes:

It looks like pg_dump was never modified to include conditional
triggers. If you look in pg_dump.c, there's no provision to dump the
FOR UPDATE OF part of the trigger declaration.

That proves nothing; it could be relying on server-side code to produce
the declaration.

This was discovered by Dave Olszewski while testing conditional triggers.

Please show a specific example of what you're worried about.

regards, tom lane

This was discovered by Dave Olszewski while testing conditional triggers.

Please show a specific example of what you're worried about.

I'll get you a reproduceable test case later today. In our testing, the
conditional part of the trigger was not being dumped.

--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com