Re: add_missing_from breaks existing views

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, andrew(at)supernews(dot)com
Subject: Re: add_missing_from breaks existing views
Date: 2005-10-30 23:22:18
Message-ID: 15606.1130714538@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus <josh(at)agliodbs(dot)com> writes:
> That sounds good if it works. However ... will an add_missing_from view work
> if add_missing_from is off in the session where the query is executed?

Yes, you only need to get it past the parser during CREATE VIEW.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sean Utt 2005-10-30 23:24:50 Re: pg_dump option to dump only functions
Previous Message Tom Lane 2005-10-30 23:17:53 slru.c race condition (was Re: TRAP: FailedAssertion("!((itemid)->lp_flags & 0x01)", )