AW: [GENERAL] Re: [HACKERS] TRANSACTIONS

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'kdebisschop(at)range(dot)infoplease(dot)com'" <kdebisschop(at)range(dot)infoplease(dot)com>
Cc: "'hackers(at)postgresql(dot)org'" <hackers(at)postgresql(dot)org>
Subject: AW: [GENERAL] Re: [HACKERS] TRANSACTIONS
Date: 2000-02-24 09:18:58
Message-ID: 219F68D65015D011A8E000006F8590C604AF7CF5@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2000-02-24 10:46:38 Re: AW: [GENERAL] Re: [HACKERS] TRANSACTIONS
Previous Message Zeugswetter Andreas SB 2000-02-24 09:08:43 AW: AW: [HACKERS] TRANSACTIONS