On Tue, 2010-09-21 at 19:55 -0400, Robert Haas wrote: > OK. This is one of the things I don't understand. Why does throwing > an error imply that we need to abort the current transaction? Why > can't we just catch the longjmp() and trundle onwards? Obviously, > that's unsafe if a pretty wide variety of cases, but if you're just > scrutinizing the input string (even with a little bit of read-only > database access) it's not obvious to me what can go wrong. (I assume > there is something, but I don't know what it is...)
The worry (from me) would be the "little bit of read-only database access". If you SPI_connect() without an SPI_finish(), that sounds like a potential problem (as would anything else that requires cleanup). Regards, Jeff Davis -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers