|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2002-04-12 12:37 UTC] rasmus@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Nov 09 01:00:01 2025 UTC |
/* TWO CONNECTIONS TO SAME SERVER, SAME DATABASE */ $conn1=pg_Connect("host=172.15.15.1 user=me dbname=mydb"); $conn2=pg_Connect("host=172.15.15.1 user=me dbname=mydb"); /* QUERIES HERE OK ON EITHER CONNECTION */ $result=pg_exec($conn1, "select stuff from table"); $result=pg_exec($conn2, "select stuff from table"); /* CLOSE conn2, conn1 SHOULD STILL BE OPEN */ $conn2=pg_close($conn2); $result=pg_exec($conn1, "select stuff from table"); // ERROR! $conn1 seems to have been closed! // MAYBE YOU ASK WHY WE DO TWO CONNS TO SAME db? // NORMALLY, THEY ARE TWO DIFFERENT db's, MAIN and // BACKUP. IN A failover SITUATION, BACKUP DB IS // DOING BOTH JOBS, SO BOTH CONNS TO SAME MACHINE // OUR PROBLEM FIXED WITH CONDITIONAL CODE: EG: IF // MAIN AND BACKUP DBS ARE SAME, DON'T MAKE SECOND // CONNECTION, BUT .... THOUGHT YOU SHOULD KNOW // ABOUT THIS.