Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] pg_dump does not fully include the schema, causing runtime errors - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] pg_dump does not fully include the schema, causing runtime errors
Date
Msg-id 20303.1506009157@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] pg_dump does not fully include the schema, causing runtime errors  ("Ian R. Campbell" <ian.campbell@thepathcentral.com>)
List pgsql-bugs
Tree view 
"Ian R. Campbell" <ian.campbell@thepathcentral.com> writes:
> pg_dump uses SET search_path in order to simplify schema references.

Yes, it does that intentionally to make the output script easier to edit.

> Can pg_dump have an option to output fully qualified schema?

I do not care to have to maintain such an option and guarantee that
both cases work.
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: "Ian R. Campbell"
Date:
Subject: [BUGS] pg_dump does not fully include the schema, causing runtime errors
Next
From: Stephen Frost
Date:
Subject: Re: [BUGS] pg_dump does not fully include the schema, causingruntime errors