Unix Technical Forum

Re: PL/pgSQL: EXCEPTION NOSAVEPOINT

This is a discussion on Re: PL/pgSQL: EXCEPTION NOSAVEPOINT within the pgsql Hackers forums, part of the PostgreSQL category; --> > In general I don't think it even makes sense to think of making > executor rollback non-transactional. Agreed. ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-11-2008, 06:33 AM
Matthew Miller
 
Posts: n/a
Default Re: PL/pgSQL: EXCEPTION NOSAVEPOINT

> In general I don't think it even makes sense to think of making
> executor rollback non-transactional.


Agreed.

I would not want to rollback some statements and not others within a
transaction. I would like a complete rollback to happen, but only when
the exception propogates out of the exception block unhandled, not when
the exception is first thrown. Maybe if I could get into the TRY
section of the PG_CATCH()/PG_TRY() construct without an intervening
elog(ERROR) then I'd have a chance ...

> Seems like your choices are
> ...
> implementing a separate expression evaluator
> ...
> make the restriction "read-only database access"
> ...


Thanks for all these ideas. I'm just getting to know the PG code tree,
and I appreciate the guidance.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:39 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com