concatenation = = transaction ????? - Mailing list pgsql-hackers

From sla-net
Subject concatenation = = transaction ?????
Date
Msg-id 001e01c360ea$8f69df80$010aa8c0@SESAMEVEDIOVIS
Whole thread Raw
In response to Re: pgstats_initstats() cost  (Gavin Sherry <swm@linuxworld.com.au>)
Responses Re: concatenation = = transaction ?????
List 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 ??????



pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: pgstats_initstats() cost
Next
From: Tom Lane
Date:
Subject: Re: pgstats_initstats() cost