PHP 4.0 Bug #7007: The pg_close function doesn't close the connection.
| From: | alex at zend dot com | Date: | Wed, 04 Oct 2000 07:05:12 +0000 |
| Subject: | PHP 4.0 Bug #7007: The pg_close function doesn't close the connection. | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-34193@lists.php.net to get a copy of this message | ||
From: alex@zend.com
Operating system: linux-glibc21
PHP version: 4.0.2
PHP Bug Type: PostgreSQL related
Bug description: The pg_close function doesn't close the connection.
The script below doesn't remove the database because the second
link is not closed and the postgres will not drop a database if there is a connection using it.
<?php
$id1 = pg_connect("host=cheese port=7655 user=zendtest password=********
dbname=template1");
pg_exec($id1, "CREATE DATABASE zendtest");
pg_close($id1);
$id2 = pg_connect("host=cheese port=7655 user=zendtest password=dnez
dbname=zendtest");
pg_close($id2);
$id3 = pg_connect("host=cheese port=7655 user=zendtest password=********
dbname=template1");
pg_exec($id3, "DROP DATABASE zendtest");
pg_close($id3);
?>