ID: 37124
User updated by: ahaig at penguinmilitia dot net
Reported By: ahaig at penguinmilitia dot net
-Status: Feedback
+Status: Open
Bug Type: PDO related
Operating System: Mac OS X 10.4.6
PHP Version: 5.1.2
New Comment:
pg_trigger.tgargs is a built in column in template1...
Looks like it's a bytea type.
(\d pg_trigger)
Previous Comments:
------------------------------------------------------------------------
[2006-04-18 18:07:37] [EMAIL PROTECTED]
What is the postgres data type you return here?
------------------------------------------------------------------------
[2006-04-18 18:04:15] ahaig at penguinmilitia dot net
I guess I didn't include <?php ?> but I thought I included a
full script. You will need to fill in $dsn $user and
$password and $table as appropriate.
$dsn should refer to a PostgreSQL DB, $table to a table with
at least 1 foreign key.
Script:
<?php
$database = new PDO( $dsn, $user, $password );
$statement = $database->prepare("SELECT t.tgargs as args
FROM pg_trigger t,pg_class c,pg_proc p WHERE t.tgenabled AND
t.tgrelid = c.oid AND t.tgfoid = p.oid AND p.proname =
'RI_FKey_check_ins' AND c.relname =:tablename ORDER BY
t.tgrelid");
$table = '<name of table in database with at least 1 foreign
key>';
$statement->bindParam( ':tablename', $table );
$statement->execute();
print_r($statement->fetchAll());
die("Here's my error!");
?>
------------------------------------------------------------------------
[2006-04-18 17:57:30] [EMAIL PROTECTED]
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.
A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc.
If possible, make the script source available online and provide
an URL to it here. Try to avoid embedding huge scripts into the report.
------------------------------------------------------------------------
[2006-04-18 17:54:08] ahaig at penguinmilitia dot net
Description:
------------
I'm using PostgreSQL 8.0.2
Query:
SELECT t.tgargs as args FROM pg_trigger t,pg_class c,pg_proc
p WHERE t.tgenabled AND t.tgrelid = c.oid AND t.tgfoid =
p.oid AND p.proname = 'RI_FKey_check_ins' AND c.relname
=:tablename ORDER BY t.tgrelid
:tablename is bound to a var with the value 'tables' (for my
particular case), and the same result occurs if I do not use
binding and fill the string in myself with 'tables' instead
of :tablename. When I run the query in psql it returns:
args
------------------------------------------------------------
tables_mainclassname_fkey\000tables\000classes
\000UNSPECIFIED\000mainclassname\000object_class\000
tables_databasehandle_fkey\000tables\000databases
\000UNSPECIFIED\000databasehandle\000databasehandle\000
(2 rows)
Reproduce code:
---------------
$statement = $my_PDO_instance->prepare("SELECT t.tgargs as args FROM
pg_trigger t,pg_class c,pg_proc p WHERE t.tgenabled AND t.tgrelid =
c.oid AND t.tgfoid = p.oid AND p.proname = 'RI_FKey_check_ins' AND
c.relname =:tablename ORDER BY t.tgrelid");
$statement->bindParam( ':tablename', $table );
$statement->execute();
print_r($statement->fetchAll());
The same thing occurs if I do:
foreach ( $my_PDO_instance->query("SELECT t.tgargs as args FROM
pg_trigger t,pg_class c,pg_proc p WHERE t.tgenabled AND t.tgrelid =
c.oid AND t.tgfoid = p.oid AND p.proname = 'RI_FKey_check_ins' AND
c.relname =:tablename ORDER BY t.tgrelid") as $this_row ) {
print_r($this_row);
}
Expected result:
----------------
Array ( [args] => tables_mainclassname_fkey\000tables
\000classes\000UNSPECIFIED\000mainclassname\000object_class
\000 ) Array ( [args] => tables_databasehandle_fkey\000tables
\000databases\000UNSPECIFIED\000databasehandle
\000databasehandle\000 )
Actual result:
--------------
Array ( [args] => Resource id #20 ) Array ( [args] => Resource
id #21 )
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=37124&edit=1
