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