rollback question - Mailing list pgsql-general

From Hegyvari Krisztian
Subject rollback question
Date
Msg-id sbfe53f8.074@ardents.hu
Whole thread Raw
Responses Re: rollback question
List pgsql-general
Greetings,

I have installed Postgresql 7.1.3 with --enable-locale and use it via PHP 4.0.6. My problem is that no kind of rollback
works.The following piece of code 

logon

insert into sorrend values ("proba");
rollback;

logoff

does not rollback anything but inserts the record into the table. The same applies when one of the queries from a
seriesfail. Everything up to the failed query is committed, nothing is rolled back. I assumed that everything would be
rolledback to the last savepoint. I thought that everything between logon and logoff is one transaction. Any ideas why
thishappens? Am I wrong at one of my assumptions? 

Best Regards,

Hegyvari Krisztian




pgsql-general by date:

Previous
From: rcaban@ccc-cable.net (roy cabaniss)
Date:
Subject: incomplete 7.1.3 update and phpPgAdmin
Next
From: marpet@linuxpl.org
Date:
Subject: Re: A newbie's opinion - postgres NEEDS a Windows binary!