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
>
> 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
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
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
One way I have approached this problem is:
1) Use PgAdmin attempt the change.
2) Examine the error report PgAdmin displays that identifies which dependent
views are preventing your progress.
3) Wrap your original DDL from step 1 within the DROP and CREATE DDL associated
with the closest dep
