Re: [GENERAL] What does this mean ?

Mario Jorge Nunes Filipe <mjnf@neptuno.sc.uevora.pt>

From: Mario Jorge Nunes Filipe <mjnf@neptuno.sc.uevora.pt>
To: "pgsql-general@postgreSQL.org" <pgsql-general@postgreSQL.org>
Date: 1999-06-25T16:01:29Z
Lists: pgsql-general
Thomas Reinke wrote:
> 
> You have already started a transaction and haven't yet
> finished it.
> 
> E.g.
> 
> psql template;
> BEGIN;
> BEGIN;

	Not that i don't believe you but i think that in my case that is a tid
bit impossible. The error comes from a php script. On that script i open
the connection, then i do a select and then the begin. So there isn't
anyother begin. I've tryed to run an abort before that but it still
doen't return a result, althoug there is no message error either.

	I really need help here, because i really need this thing working with
transactions. Just in case here is the code:

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


When running this i always get an alert box saying "sac-pcgra(2):".

What is wrong?

Thanks

-- 
        Mario Filipe 
        mjnf@uevora.pt
        http://neptuno.sc.uevora.pt/~mjnf