Re: Alter view with dependence without drop view!

2018-01-30 Thread Thomas Kellerer
Elson Vaz schrieb am 30.01.2018 um 14:40: Hello! I want make change in one view that have dependence view's, so when i try to make change i'm block because of this, what is the best solution?? This can easily be dealt with when using a schema management tool. We use Liquibase for this and t

Re: Alter view with dependence without drop view!

2018-01-30 Thread Ken Tanzer
> > I want make change in one view that have dependence view's, so when i try > to make change i'm block because of this, what is the best solution?? Just to be clear, there are some changes you can make, some you can't. Basically you can't change the definition of existing columns in the view. B

Re: Alter view with dependence without drop view!

2018-01-30 Thread Melvin Davidson
On Tue, Jan 30, 2018 at 12:48 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tue, Jan 30, 2018 at 8:34 AM, bto...@computer.org < > bto...@broadstripe.net> wrote: > >> >> When this procedure got old, I started using a script created using >> pg_dump and pg_restore, as initially out

Re: Alter view with dependence without drop view!

2018-01-30 Thread David G. Johnston
On Tue, Jan 30, 2018 at 8:34 AM, bto...@computer.org 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 co

Re: Alter view with dependence without drop view!

2018-01-30 Thread bto...@computer.org
-e3cff914357b%40computer.org -- B - Original Message - From: "Elson Vaz" To: pgsql-general@lists.postgresql.org Sent: Tuesday, January 30, 2018 8:40:45 AM Subject: Alter view with dependence without drop view! Hello! I want make change in one view that have depende

Alter view with dependence without drop view!

2018-01-30 Thread Elson Vaz
Hello! I want make change in one view that have dependence view's, so when i try to make change i'm block because of this, what is the best solution?? thank you!! best regard Elson Vaz