Problem with transaction

Thread View: borland.public.interbase.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Gon�alo Martins Wed, 27 Nov 2002 12:06

#11306

Author: Gon�alo Martins
Date: Wed, 27 Nov 2002 12:06

17 lines
1690 bytes

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

Re: Problem with transaction

#11316

Author: Bill Todd
Date: Wed, 27 Nov 2002 14:23

30 lines
2061 bytes

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)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads