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
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 |