AW: [GENERAL] Re: [HACKERS] TRANSACTIONS

Zeugswetter Andreas SB <zeugswettera@wien.spardat.at>

From: Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
To: "'kdebisschop@range.infoplease.com'" <kdebisschop@range.infoplease.com>
Cc: "'hackers@postgresql.org'" <hackers@postgresql.org>
Date: 2000-02-24T09:18:58Z
Lists: pgsql-hackers
> ========================= example =========================
> 
> $dbh->{AutoCommit} = 0;
> $dbh->do("CREATE TABLE tmp (a int unique,b int)");
> while (<>){
>     if (/([0-9]+) ([0-9]+)/) {
> 	$rtv = $dbh->do("INSERT INTO tmp VALUES ($1,$2)");
> 	if ($rtv) {$dbh->do("UPDATE tmp SET b=$2 where a=$1")};
>     }
> }
> $dbh->commit;
> $dbh->disconnect;
> 
> ========================= end ============================

This is a very good example, and is unfortunately currently not possible in 
PostgreSQL. But I am sure Vadim is on his way to fix that :-)

Andreas