Go to:
Gentoo Home
Documentation
Forums
Lists
Bugs
Planet
Store
Wiki
Get Gentoo!
Gentoo's Bugzilla – Attachment 272543 Details for
Bug 366509
dev-db/libdbi-drivers-0.8.3: uses incorrect query for listing tables on PostgreSQL database
Home
|
New
–
[Ex]
|
Browse
|
Search
|
Privacy Policy
|
[?]
|
Reports
|
Requests
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Changed query
dbd_pgsql.c.diff (text/plain), 1.17 KB, created by
Sergey Otinov
on 2011-05-08 22:49:42 UTC
(
hide
)
Description:
Changed query
Filename:
MIME Type:
Creator:
Sergey Otinov
Created:
2011-05-08 22:49:42 UTC
Size:
1.17 KB
patch
obsolete
>--- libdbi-drivers-0.8.3-1.orig/drivers/pgsql/dbd_pgsql.c 2008-01-26 20:39:50.000000000 +0300 >+++ libdbi-drivers-0.8.3-1/drivers/pgsql/dbd_pgsql.c 2011-05-09 02:20:00.000000000 +0400 >@@ -426,10 +426,10 @@ > } > > if (pattern == NULL) { >- return (dbi_result_t *)dbi_conn_queryf((dbi_conn)conn, "SELECT relname FROM pg_class WHERE relname !~ '^pg_' AND relkind = 'r' AND relowner = (SELECT datdba FROM pg_database WHERE datname = '%s') ORDER BY relname", db); >+ return (dbi_result_t *)dbi_conn_queryf((dbi_conn)conn, "SELECT relname FROM pg_class WHERE relname !~ '^pg_' AND relkind = 'r' AND relowner = (SELECT usesysid FROM pg_user WHERE usename = user) ORDER BY relname"); > } > else { >- return (dbi_result_t *)dbi_conn_queryf((dbi_conn)conn, "SELECT relname FROM pg_class WHERE relname !~ '^pg_' AND relname LIKE '%s' AND relkind = 'r' AND relowner = (SELECT datdba FROM pg_database WHERE datname = '%s') ORDER BY relname", pattern, db); >+ return (dbi_result_t *)dbi_conn_queryf((dbi_conn)conn, "SELECT relname FROM pg_class WHERE relname !~ '^pg_' AND relname LIKE '%s' AND relkind = 'r' AND relowner = (SELECT usesysid FROM pg_user WHERE usename = user) ORDER BY relname", pattern); > } > } >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
Attachments on
bug 366509
: 272543