Re: pg_dump/restore and functions/triggers/trigger functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Amiel <becauseimjeff(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump/restore and functions/triggers/trigger functions
Date: 2007-02-06 23:26:36
Message-ID: 25618.1170804396@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff Amiel <becauseimjeff(at)yahoo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message MargaretGillon 2007-02-06 23:28:32 Limit for number of Joins in a View? Version 8.1.4 on Redhat 9
Previous Message Tom Lane 2007-02-06 23:12:22 Re: pg_dump/restore and functions/triggers/trigger functions