Re: [PHP] pg_query and COPY in transaction

[Chris]

Luis Magaña wrote:
I have the following code:
pg_query($conn,"BEGIN TRANSACTION;
          DELETE FROM codigo_postal;
          COPY
codigo_postal(codigo_postal,asentamiento,tipo_asentamiento,municipio,estado)
FROM '$tmpfname2' DELIMITER '|';
          COMMIT");

Separate them out as a first step:

$result = pg_query("begin");
if (!$result) {
  echo "error at line " . __LINE__ . ": " . pg_last_error() . "<br/>";
}

$result = pg_query("delete from codigo_postal;");
if (!$result) {
  echo "error at line " . __LINE__ . ": " . pg_last_error() . "<br/>";
}

$result = pg_query("COPY 
codigo_postal(codigo_postal,asentamiento,tipo_asentamiento,municipio,estado) 
FROM '$tmpfname2' DELIMITER '|';");
if (!$result) {
  echo "error at line " . __LINE__ . ": " . pg_last_error() . "<br/>";
}

$result = pg_query("commit");
if (!$result) {
  echo "error at line " . __LINE__ . ": " . pg_last_error() . "<br/>";
}

and see if you get any errors.

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php