#26592 [Com]: PostgreSQL 7.4 has autocomit option left to client

ID: 26592 Comment by: scott dot marlowe at ihs dot com Reported By: aspire420 at hotpop dot com Status: Open Bug Type: PostgreSQL related Operating System: Linux RH 9.0 PHP Version: 4.3.4 New Comment: QUOTE: What if my app has a multi-request series of action that should succeed or fail as a group? UNQUOTE: Then you need to enclose them in begin;/end; pairs. Simple enough. Previous Comments: ------------------------------------------------------------------------ [2003-12-11 17:22:59] not at anumber dot com Autocommit considered harmful. The consumers of database resources within an application server should decide how transactional behaviour works, not the application server itself. This is analogous to the rule (now, too frequently broken) that MTAs should not mess with message bodies. What if my app has a multi-request series of action that should succeed or fail as a group? ------------------------------------------------------------------------ [2003-12-11 17:14:02] peter_e at gmx dot net This is actually a pretty bad idea. The autocommit setting should be controlled either by making it fixed at on or off for the interface, or by the client program itself (e.g., a "set autocommit on" function), but not by a global setting, because then you'll never be able to reconcile various prepackaged PHP applications. The excessive global-ness was the reason that the server-side autocommit setting was removed in the first place. ------------------------------------------------------------------------ [2003-12-11 16:37:03] aspire420 at hotpop dot com some configuration string would be better ------------------------------------------------------------------------ [2003-12-11 16:22:01] aspire420 at hotpop dot com Description: ------------ As on PostgreSQL version 7.4 the autocommit option has been rested upon the client side i.e if I would like to put autocommit = off in PostgreSQL 7.4 > then it must appear some where in PHP.INI. But till the latest version of PHP I dont see any such option. Expected result: ---------------- in PHP.ini PostgreSQL autocommit = off or may be we do it with some configure strings ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=26592&edit=1