Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump/restore and functions/triggers/trigger functions - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump/restore and functions/triggers/trigger functions
Date
Msg-id 25460.1170803542@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump/restore and functions/triggers/trigger functions  (Jeff Amiel <becauseimjeff@yahoo.com>)
Responses Re: pg_dump/restore and functions/triggers/trigger functions  (Jeff Amiel <becauseimjeff@yahoo.com>)
List pgsql-general
Tree view 
Jeff Amiel <becauseimjeff@yahoo.com> writes:
> did a pg_dump --format=c for a production database (on a 8.1.2 server) and attempted to pg_restore on a 8.2.0 server.

> Things seemed to go fine with the exception of functions, triggers and trigger functions.

Seems pretty strange.  Can you strip this down to a reproducible test
case?

            regards, tom lane

pgsql-general by date:

Previous
From: Jeff Amiel
Date:
Subject: Re: pg_dump/restore and functions/triggers/trigger functions
Next
From: Tom Lane
Date:
Subject: Re: pg_dump/restore and functions/triggers/trigger functions