php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #7333 Connection fault in circled query
Submitted: 2000-10-19 03:57 UTC Modified: 2001-02-13 12:09 UTC
From: wangii at 21cn dot com Assigned:
Status: Closed Package: PostgreSQL related
PHP Version: 4.0.3pl1 OS: Linux
Private report: No CVE-ID: None
 [2000-10-19 03:57 UTC] wangii at 21cn dot com
In order to use posgressql6.5.1,i designed a simple function like  this:
function sim()
{$conn=pg_connect($connoptions);
 $result=pg_result($conn,"....");
 ....
 pg_freeresult($result);
 pg_close($conn);}

when i use a for() circle to use the function, there's problem.
each first time use the funtion, it's ok, but the sencond time, it goes wronglike this:
Warning: 1 is not a valid PostgreSQL link resource in .... on line ...
and the third time ,It runs well.and the fourth time, mistakes happened again. and so on.
I've track the $conn, the resource id  are:#1,#1,#7....

When i turned to mysql, thereis no problem.

Sorry for my poor english.
Regards

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-10-20 04:44 UTC] wangii at 21cn dot com
And so it does in postgressql 7.0.2.
 [2001-02-13 12:09 UTC] thies@php.net
believed to be fixed in CVS
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Apr 23 22:01:31 2024 UTC