php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #35996 pg_meta_data should take the schema into account
Submitted: 2006-01-13 15:42 UTC Modified: 2008-10-16 00:46 UTC
From: G dot Gersdorf at tu-bs dot de Assigned:
Status: Closed Package: PostgreSQL related
PHP Version: 5.1.2 OS: Linux
Private report: No CVE-ID: None
View Developer Edit
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: G dot Gersdorf at tu-bs dot de
New email:
PHP Version: OS:

 

 [2006-01-13 15:42 UTC] G dot Gersdorf at tu-bs dot de 
Description:
------------
If a database contains tables with the same name in different schemas, requesting the meta data for this table returns a mix for all fields in all that tables.

The select statement use is something like
  SELECT a.attname, a.attnum, t.typname, a.attlen,
    a.attnotNULL, a.atthasdef, a.attndims
  FROM pg_class as c, pg_attribute a, pg_type t
  WHERE a.attnum > 0 AND a.attrelid = c.oid AND
    c.relname='$table' AND a.atttypid = t.oid
  ORDER BY a.attnum

but should be something like
  SELECT a.attname, a.attnum, t.typname, a.attlen,
    a.attnotNULL, a.atthasdef, a.attndims
  FROM pg_class as c, pg_attribute a, pg_type t,
      pg_namespace n
  WHERE a.attnum > 0 AND a.attrelid = c.oid AND
    c.relname='$table' AND a.atttypid = t.oid
      AND c.relnamespace=n.oid AND n.nspname='$schema'
  ORDER BY a.attnum

where $schema='public' as default

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-01-13 15:56 UTC] tony2001@php.net 
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to "Open".

Thank you for your interest in PHP.
 [2006-01-21 01:00 UTC] php-bugs at lists dot php dot net 
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 [2008-10-16 00:46 UTC] felipe@php.net 
This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
 
Thank you for the report, and for helping us make PHP better.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Wed Dec 11 21:01:28 2024 UTC