🚀 go-pugleaf

There is no solution AFAIK. You have to commit the transaction that
drops the dependent objects before you can drop the view.

On Wed, 27 Nov 2002 12:06:32 -0000, "Gon�alo Martins"
<gmartins@netcabo.pt> wrote:

>I've posted this in the end of another post, but I would like to make a new
>post out of it since the subject it's diferent of the post it was in.
>Here it goes
>
>The situation is this: I want to change a view, but a lot of procedures use
>it.
>Ok, I'm dropping all the procedures and then drop the view and reconstruct
>all.
>I want to do this in one transaction but I get this error:
>I drop all the procedures that use the view and then the view. When I do
>this, it gives an error"View MYVIEW is in use". If I do a commit before I do
>the drop of the view, then the drop of the view works...
>Any tips on this? I would like to do all this in one transaction so the DB
>doesn't stay in an incorrect state if an error occurs.
>Thanks
>
>Gon�alo
>
>


--
Bill (TeamB)
(TeamB cannot respond to questions received via email)