Re: add_missing_from breaks existing views

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: andrew(at)supernews(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: add_missing_from breaks existing views
Date: 2005-10-26 03:55:44
Message-ID: 1445.1130298944@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andrew - Supernews <andrew+nonews(at)supernews(dot)com> 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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Klint Gore 2005-10-26 04:23:20 Re: BUG #1993: Adding/subtracting negative time intervals
Previous Message Bruce Momjian 2005-10-26 03:41:54 Re: BUG #1993: Adding/subtracting negative time intervals