| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.12.2 |
| Bug #1549 | getSpecialQuery() method problem | ||
|---|---|---|---|
| Submitted: | 2004-06-03 06:52 UTC | ||
| From: | iwakiri | Assigned: | danielc |
| Status: | Closed | Package: | DB |
| PHP Version: | 5CVS-2004-06-03 (dev) | OS: | *nix |
| Roadmaps: | (Not assigned) | ||
[2004-06-03 06:52 UTC] iwakiri
Description:
------------
getSpecialQuery() can't access `PostgreSQL CORE TABLE'.
Those tables are sql_* .
(added PostgreSQL version 7.4.2)
This problem occurs PostgreSQL 7.4.2 or later.
I want you to try patch of the following.
Index: pear/DB/DB/pgsql.php
===================================================================
RCS file: /repository/pear/DB/DB/pgsql.php,v
retrieving revision 1.75
diff -u -u -r1.75 pgsql.php
--- pear/DB/DB/pgsql.php 7 Apr 2004 05:12:28 -0000 1.75
+++ pear/DB/DB/pgsql.php 3 Jun 2004 06:48:15 -0000
@@ -808,7 +808,7 @@
WHERE c.relkind = 'r'
AND not exists (select 1 from pg_views where viewname =
c.relname)
AND not exists (select 1 from pg_user where usesysid =
c.relowner)
- AND c.relname !~ '^pg_'";
+ AND c.relname !~ '^(pg_|sql_)'";
case 'views':
// Table cols: viewname | viewowner | definition
return 'SELECT viewname FROM pg_views';
Comments
[2004-06-17 15:43 UTC] jpbarrette at savoirfairelinux dot net
in fact you should change the first c.relname !~ '^pg_' to
be changed to '^(pg_|sql_)' not the second.
[2004-06-19 03:00 UTC] iwakiri
Thank you for comment.
previus patch is wrong.
Index: pear/DB/DB/pgsql.php
===================================================================
RCS file: /repository/pear/DB/DB/pgsql.php,v
retrieving revision 1.75
diff -u -r1.75 pgsql.php
--- pear/DB/DB/pgsql.php 7 Apr 2004 05:12:28 -0000 1.75
+++ pear/DB/DB/pgsql.php 19 Jun 2004 03:04:40 -0000
@@ -801,7 +801,7 @@
FROM pg_class c, pg_user u
WHERE c.relowner = u.usesysid AND c.relkind = 'r'
AND not exists (select 1 from pg_views where viewname =
c.relname)
- AND c.relname !~ '^pg_'
+ AND c.relname !~ '^(pg_|sql_)'
UNION
SELECT c.relname as \"Name\"
FROM pg_class c