concatenation = = transaction ?????

From: "sla-net" <slambert(at)vediovis(dot)net>
To: "PostgreSQL Development" <pgsql-hackers(at)postgresql(dot)org>
Subject: concatenation = = transaction ?????
Date: 2003-08-12 15:58:23
Message-ID: 001e01c360ea$8f69df80$010aa8c0@SESAMEVEDIOVIS
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi everybody

It's my first post here, so be indulgent ;)

Just to confirm : if i do

$sql1='insert into "Enfant" ("NomEnfant","PrenomEnfant") VALUES
('.$NomEnfant.','.$PrenomEnfant.')

$sql2='insert into "IndividuEnfant" ("IdIndividu","IdEnfant") VALUES
('.$IdIndividu.',currval(\'"Enfant_Seq"\'));

$sql=$sql1.$sql2;

$Res=pg_query($sql);

so 2 query concatenation a a only one, send to postgress database : is it
EXACTLY the same thing than a classic transaction with a begin and a commit
or rollback ?

Tcks, it's just i dont want to write everything again in 6 months.....

S.L.

PS : why limitation to 8 patrameters in stored procedures ??????

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-08-12 16:23:20 Re: pgstats_initstats() cost
Previous Message Rod Taylor 2003-08-12 15:28:50 pg_dump and REVOKE on function