On 2005-10-26, Tom Lane <[EMAIL PROTECTED]> wrote: > Andrew - Supernews <[EMAIL PROTECTED]> writes: >> Wild idea: how about having pg_dump include SET add_missing_from = true; >> in the dump file if, and only if, it is set that way in the server? > > Uh, no ... the global setting of add_missing_from does *not* tell you > anything about whether there exist views in the database that were > created under a different setting.
I realize that; but is it also not the case that someone who creates a view that requires add_missing_from, and then turns it off, has _already_ broken dump+restore on his own database? i.e. people who turn off add_missing_from intentionally are not likely to be using it. -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
