php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #61805 Does not behave as expected when NOTICE issued
Submitted: 2012-04-22 00:28 UTC Modified: 2012-04-22 00:32 UTC
From: keiouu at gmail dot com Assigned:
Status: Closed Package: PostgreSQL related
PHP Version: 5.3.10 OS: Ubuntu 12.04
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: keiouu at gmail dot com
New email:
PHP Version: OS:

 

 [2012-04-22 00:28 UTC] keiouu at gmail dot com
Description:
------------
Hello,

I have the following script:

pg_query("DROP SEQUENCE IF EXISTS test_seq;");

Have also tried:

pg_query('DROP SEQUENCE IF EXISTS "test_seq";');

Both issue warnings:

E_WARNING: pg_query(): Query failed: ERROR:  relation "test_seq" does not exist 
in /home/keiouu/tikapot/framework/databases/postgres.php on line 64
Exception 1!


Which would be fine but I have set:

pgsql.ignore_notice = 1


A phpinfo confirmed that it is set.

As there is no easy way of seeing if a sequence exists (that I know of) I don't 
believe any warning should be issued.

Test script:
---------------
pg_query("DROP SEQUENCE IF EXISTS test_seq;");

Expected result:
----------------
Nothing

Actual result:
--------------
E_WARNING: pg_query(): Query failed: ERROR:  relation "test_seq" does not exist 
in /home/keiouu/tikapot/framework/databases/postgres.php on line 64
Exception 1!

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2012-04-22 00:32 UTC] keiouu at gmail dot com
It was an issue with my setup, one worker hadnt been restarted to get the new 
configuration.
 [2012-04-22 00:32 UTC] keiouu at gmail dot com
-Status: Open +Status: Closed
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Tue May 06 23:01:28 2025 UTC