Re: pg_dump does not fully include the schema, causing runtime errors

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ian R(dot) Campbell" <ian(dot)campbell(at)thepathcentral(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_dump does not fully include the schema, causing runtime errors
Date: 2017-09-21 15:52:37
Message-ID: 20303.1506009157@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Ian R. Campbell" <ian(dot)campbell(at)thepathcentral(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephen Frost 2017-09-21 21:31:15 Re: pg_dump does not fully include the schema, causing runtime errors
Previous Message Ian R. Campbell 2017-09-21 14:20:28 pg_dump does not fully include the schema, causing runtime errors