The following bug has been logged online: Bug reference: 5390 Logged by: Timothy Seever Email address: tim.see...@gmail.com PostgreSQL version: 8.3.5, others Operating system: Linux/RHEL5.2 Description: pg_dump does not check/include additional schema dependencies when writing schema/search path Details:
To reproduce: 1. Create schema A 2. Create schema B 3. Create function in schema A which depends on something in schema B without specifying it (i.e. the connected user has B included in the search_path, and the function A.xyz() has something like val := yyz(); where yyz is actually B.yyz. 4. This works properly in place due to the search path... however upon dumping/restoring, pg_dump only specifies the single schema+public before each section, so it will fail to add A.xyz()/view/etc leading to cascaded missing items. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
