php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #7236 1 is not a valid PostgreSQL link resource
Submitted: 2000-10-16 06:57 UTC Modified: 2001-02-13 12:01 UTC
From: chris at chrullrich dot de Assigned:
Status: Closed Package: PostgreSQL related
PHP Version: 4.0.3pl1 OS: Linux x86
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: chris at chrullrich dot de
New email:
PHP Version: OS:

 

 [2000-10-16 06:57 UTC] chris at chrullrich dot de
Since 4.0.3, PHP reports the error given in the bug description. I checked the returned value before:

----------------------------------------------------

  $conn = pg_connect("dbname=" . VEDB_DBNAME);
  if (!$conn)
    {
      fatal_error("Could not connect to database", __FILE__, __LINE__);
    }
	
  $query = "select $field from $table where $field = '$_value'";
	
  $res = pg_exec($conn, $query);

----------------------------------------------------

I can't really understand why that error occurs in the last line (pg_exec).

configure line:
./configure' '--with-apxs=/usr/lib/apache/bin/apxs' '--without-mysql' '--with-config-file-path=/etc/php4' '--sysconfdir=/etc/php4' '--with-pgsql=/usr/lib/pgsql' '--with-gnu-ld' '--enable-magic-quotes' '--enable-bcmath' '--enable-calendar' '--with-gdbm' '--with-db3' '--with-gd=/usr' '--with-ttf' '--with-gettext' '--with-readline' '--with-sysvsem' '--with-sysvshm' '--enable-versioning'

I use PostgreSQL 7.0.2.

The very same script runs flawlessly with PHP 4.0.2.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-02-13 12:01 UTC] thies@php.net
fixed in CVS
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Thu Jul 03 13:01:33 2025 UTC