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

[Jeff Amiel <becauseimjeff@xxxxxxxxx>]

Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

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?

yes...ALL my functions did indeed fail to load.
  Weirdness is that I only saw errors on the GRANT/REVOKE failures.
  Huh.
  
  I created a simple test case with a single function...got the same results.
  I removed the --schema='public' and it worked fine.
  I compared the TOCs on the 2 different files and sure enough, there is an entry on the one that DIDN'T only use public that had the plpgsql entry.
  
  248; 2612 90212 PROCEDURAL LANGUAGE - plpgsql
  
 Huh.  I
 guess if I added plpgsql to template1 before I created the empty shell db to restore into, I would never have seen this issue.
  Ok....
  I guess the real question is (other than related to this issue), it there any need to dump the catalog/informational schemas?

---

Finding fabulous fares is fun.
Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains.