Auto commit Off how will it effect us ?

From: SaiHertz And Control Systems <sank89(at)sancharnet(dot)in>
To: pgsql-novice(at)postgresql(dot)org, pgsql-php(at)postgresql(dot)org
Subject: Auto commit Off how will it effect us ?
Date: 2003-12-03 16:33:09
Message-ID: 3FCE1045.6010604@sancharnet.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-php

Dear all ,

Permit me to gain some of your most valuable knowledge ...........

Our intrAnet server has the following spec
1. RH 9.0
2. Postgresql 7.3.4
3. PHP 4.3.3
4. GCC 3.2.2

Till date my front end language (PHP) use to simply pass the data to
postgresql in case of insert and
update we were not using
1 BEGIN COMMIT block in PHP till date thanks to auto-commit-ON in postgreql
2. ROLLBACK script in PHP script

And now when our company has decided to switch over to postgresql 7.4
we have some doubt
1. Do we have to include BEGIN and COMMIT block around the insert
process . (Because Postgresql 7.4 has auto-commit-OFF) in our PHP scripts
2. Not only this do we also have to port the pgSQL functions which use
to do inserts into a third table such that
data gets committed on function execution

Please provide us any kinda information so that we can happily switch to
postgressql 7.4

Regards,
V Kashyap

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message hodges 2003-12-03 19:03:18 comparring dates between perl and postgres
Previous Message Tom Lane 2003-12-03 16:07:07 Re: multiline PL/Python function fails in *.sql

Browse pgsql-php by date

  From Date Subject
Next Message CoL 2003-12-06 01:07:46 Re: Auto commit Off how will it effect us ?
Previous Message Greg Spiegelberg 2003-12-01 17:40:31 Re: error on Database insert (off-topic)