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

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4067145
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to