Skip site navigation (1) Skip section navigation (2)

Re: add_missing_from breaks existing views

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org, andrew(at)supernews(dot)com
Subject: Re: add_missing_from breaks existing views
Date: 2005-10-31 00:49:29
Message-ID: 200510301649.29975.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom,

> > 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.

Then the proposal sounds like a good solution to me.   It would still be nice 
to emit a warning, as well, if that's reasonably easy to do.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

pgsql-hackers by date

Next:From: Josh BerkusDate: 2005-10-31 01:31:07
Subject: Re: FKs on temp tables: hard, or just omitted?
Previous:From: Sean UttDate: 2005-10-30 23:24:50
Subject: Re: pg_dump option to dump only functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group