On Mon, Aug 12, 2013 at 12:28:26PM -0400, Peter Eisentraut wrote: > On 8/9/13 12:04 AM, Bruce Momjian wrote: > > generates this output: > > > > SET search_path = xx, pg_catalog; > > CREATE TABLE test ( > > x integer > > ); > > > > If you dump a schema and want to reload it into another schema, you > > should only need to update that one search_path line. > > Is anyone actually using that feature? It doesn't seem very reliable. > You can't just change the schema name in one or two places. You'd have > to manually inspect function source code, for example.
True. I think the larger issue is that we use search_path to avoid specifying the schema name in lots of places, and SET OWNER should do the same. I think the schema reload case is just a side-effect. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
