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 25618.1170804396@sss.pgh.pa.us
Whole thread Raw
In response to 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:
> The original pg_dump used --schema="public" .

I think that would have excluded anything that didn't demonstrably
belong to schema public, such as procedural languages.  Is it possible
that *all* your functions failed to load, and you only noted the ensuing
GRANT/REVOKE failures?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump/restore and functions/triggers/trigger functions
Next
From: andrea@cpushare.com
Date:
Subject: Re: regression in 8.8.2 [was Re: Very strange error]