Thanks for the example, I used something similar myself ;)
I don't run plsql in auto-commit mode, so I wrapped the script with BEGIN/COMMIT - but
as soon as you get an error inside a transaction you have to roll back, hence removing the
drop statements.
It's nice to know that there are other people using PostgreSQL (I'm on 8.2).
Cheers,
Andy
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4067145#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...