Re: Concurrent testing PostgreSQL Vs MySQL

From: Marek Lewczuk <newsy(at)lewczuk(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Concurrent testing PostgreSQL Vs MySQL
Date: 2003-11-21 10:18:57
Message-ID: 3FBDE691.5070204@lewczuk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Użytkownik Durai napisał:

> Hello Shridhar,
>
> The script content is:
> ** *# cat te**stpgsql.php*
> *
> *<?php
> $dbconn = pg_connect("host=172.16.1.158 port=5432 dbname=test
user=postgres");
> $result = pg_exec ($dbconn, "update table2 set C2=C2+1;");
> $result = pg_exec ($dbconn, "update table2 set C2=C2-1;");
> pg_close($dbconn);

You have to read about transactions in PostgreSQL or you should turn on
autocommit in conf file...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrei Ivanov 2003-11-21 10:29:12 Re: ERROR: nodeRead: did not find '}' [x2]
Previous Message Durai 2003-11-21 10:09:42 Re: Concurrent testing PostgreSQL Vs MySQL