Is a dropped (or altered) function still available inside already opened transactions?
8
votes
2
answers
463
views
I found
- https://dba.stackexchange.com/q/126734/104401
but there are no answers and isn't exactly the same as my question (though very similar).
-------
Let's say I do the following:
1. Create a function
myfunc()
2. Start a transaction from client A
3. Start a transaction from client B
4. In transaction B, use "create or replace function" to revise the definition of myfunc()
5. Commit transaction B
6. Call myfunc()
from transaction A
**What happens in step 6?** Am I calling the original function as defined in step 1? Or the modified form from step 4 (committed in step 5)?
-----
And if the function is dropped in step 4 rather than being modified, will step 6 fail or succeed? (This is probably the same question but modifications may work differently.)
----
Where is the documentation about this?
Asked by Wildcard
(587 rep)
Dec 23, 2017, 01:59 AM
Last activity: Dec 24, 2017, 06:29 AM
Last activity: Dec 24, 2017, 06:29 AM