Re: Alter view with dependence without drop view! - Mailing list pgsql-general

From David G. Johnston
Subject Re: Alter view with dependence without drop view!
Date
Msg-id CAKFQuwa31aUfv3K2CbpBaaGkxswOp6y-NdqPEO6Nkv1ahV7GUw@mail.gmail.com
Whole thread Raw
In response to Re: Alter view with dependence without drop view!  ("btober@computer.org" <btober@broadstripe.net>)
Responses Re: Alter view with dependence without drop view!
List pgsql-general
On Tue, Jan 30, 2018 at 8:34 AM, btober@computer.org <btober@broadstripe.net> wrote:

When this procedure got old, I started using a script created using pg_dump and pg_restore, as initially outlined here:


​Yeah, the short answer is PostgreSQL doesn't make it possible to edit "middle" views without having the code on hand for all dependent views​ so you can recreate them.  You either maintain those views and order manually or you rely on pg_dump to figure it out for you (the former, with version control, is highly recommended).

I could see it being possible to program the server to be more helpful here - by say allowing it to drop but remember view definitions and the re-create them from the remembered versions by name - but no one has seen the motivation to do so; I suspect partially in light of the fact that "version control" is a recommended practice.

David J.

pgsql-general by date:

Previous
From: Stefan Blanke
Date:
Subject: ERROR: invalid memory alloc request size 1073741824
Next
From: HIRTZ Jorge Alberto TENARIS
Date:
Subject: RE: PostgreSQL Kerberos Authentication