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

Re: add_missing_from breaks existing views

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org, andrew(at)supernews(dot)com
Subject: Re: add_missing_from breaks existing views
Date: 2005-10-30 20:04:13
Message-ID: 200510301204.13733.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Andrew,

> My suggestion was to set add_missing_from _in the output of pg_dump_ (or
> pg_restore) so that affected views would restore correctly. This would
> affect only the session in which the dump was restored. The changes that
> were already suggested (and since implemented, iiuc) would then make this
> unnecessary for future dumps/restores, and there would be no question of
> setting
> add_missing_from globally in the 8.1 database (unless the admin did that
> explicitly, themselves).

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?   If 
not, then I don't really find this  a solution.  In that case, it would be 
better to supply a script that allows users to find add_missing_from 
dependant views so they can fix them.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

pgsql-hackers by date

Next:From: Magnus HaganderDate: 2005-10-30 20:24:38
Subject: Re: 8.1 Release Candidate 1 Bundled ...
Previous:From: Gregory MaxwellDate: 2005-10-30 16:49:41
Subject: Re: Differences in UTF8 between 8.0 and 8.1

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