Re: [GENERAL] What does this mean ? - Mailing list pgsql-general

From Remigiusz Sokolowski
Subject Re: [GENERAL] What does this mean ?
Date
Msg-id Pine.GS4.4.02A.9906280805390.7483-100000@netra.gdansk.sprint.pl
Whole thread Raw
In response to Re: [GENERAL] What does this mean ?  (Mario Jorge Nunes Filipe <mjnf@neptuno.sc.uevora.pt>)
List pgsql-general
>
> pg_Exec($conn, "abort");
> $result = @pg_Exec($conn, "begin");
> if (!$result);
>   $msg ="sac-pcgra (2):".addslashes(pg_ErrorMessage($conn));
>   $msg = chop($msg);
>   echo "<script>alert(\"$msg\");history.go(-1)</script>";
>   pg_Close($conn);
>   exit;
> }

Error is that You just dont END your transaction
before pg_Close You should have a line pg_Exec( $conn, "END;" );
pg_Close closes Your connection, but doesn't end Your transactions
    Rem

-------------------------------------------------------------------*------------
Remigiusz Sokolowski      e-mail: rems@gdansk.sprint.pl           * *
-----------------------------------------------------------------*****----------


pgsql-general by date:

Previous
From: "Hub.Org News Admin"
Date:
Subject: ...
Next
From: "Ansley, Michael"
Date:
Subject: RE: pgsql-general-digest V1 #365