Joseph Shraibman wrote:
> 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.
There is absolutely nothing that could be set to "disable" it
and continue the transaction. This is because the system has
no idea how to distinguish between a syntax typo and a
duplicate key error for example. Both are simply and ERROR.
Now for a typo it'd not be critical, but for a dupkey - er -
the heap typle is there, not all indexes might have been
processed and for sure the referential integrity constraint
triggers and other stuff haven't been run. That's an
inconsistent DB state, isn't it? Are you sure you want that?
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com