pypgsql-users

[Pypgsql-users] db.commit()

[Timothy S. <ti...@op...>]

can anyone point me to some docs or explainf .commit() for me. what i'm 
intrested in is what happens if i perform some actions, but say i find 
an error and do not want to commit those. if i do db.close() are thos 
updates/inserts cancled?

Re: [Pypgsql-users] db.commit()

[Gerhard H. <gh...@gh...>]

On Mon, Nov 22, 2004 at 01:03:04PM +1000, Timothy Smith wrote:
> can anyone point me to some docs or explainf .commit() for me. what i'm=
=20
> intrested in is what happens if i perform some actions, but say i find=20
> an error and do not want to commit those. if i do db.close() are thos=20
> updates/inserts cancled?

To discard the changes, use .rollback() on the connection object.

Btw. a .close() does an implicit .rollback().

-- Gerhard

Re: [Pypgsql-users] db.commit()

[Timothy S. <ti...@op...>]

.rollback(), can i rollback the the last commit for the db object?

Gerhard Haering wrote:

>On Mon, Nov 22, 2004 at 01:03:04PM +1000, Timothy Smith wrote:
>  
>
>>can anyone point me to some docs or explainf .commit() for me. what i'm 
>>intrested in is what happens if i perform some actions, but say i find 
>>an error and do not want to commit those. if i do db.close() are thos 
>>updates/inserts cancled?
>>    
>>
>
>To discard the changes, use .rollback() on the connection object.
>
>Btw. a .close() does an implicit .rollback().
>
>-- Gerhard
>  
>

Re: [Pypgsql-users] db.commit()

[Gerhard H. <gh...@gh...>]

On Mon, Nov 22, 2004 at 07:06:38PM +1000, Timothy Smith wrote:
> .rollback(), can i rollback the the last commit for the db object?

An explanation might be this:

changes are accumulated until you COMMIT or ROLLBACK the transaction.
They are accumulated fro mthe point you commited or rolled back the
last time. If you .commit() then the changes are permanent. If you
rollback, then you discard the changes.

You cannot undo changes that you already committed with a single
command.

-- Gerhard
--=20
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?