Re: [HACKERS] Conditional trigger missing from pg_dump

От:

Tom Lane <tgl@sss.pgh.pa.us>

Дата:

25 марта 2010 г. в 14:45:56

Josh Berkus  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

Conditional trigger missing from pg_dump

От:

Josh Berkus <josh@agliodbs.com>

Дата:

25 марта 2010 г. в 14:41:58

All,

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.

This was discovered by Dave Olszewski while testing conditional triggers.

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