Mike Finn wrote:
>
> problem but I was wondering why this occurs, and if it is on the todo list to
> fix.
It occurs because once an error happens all the changes that have been
made may not mean anything, so the transaction must be rolled back.
Maybe there is something that could be set to interactive programs like
psql can disable this? If not there should be, becuase I too have been
anoyed with a long interactive session having to be restarted because of
a typo.
--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com