From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | obj_description problems? |
Date: | 2003-10-21 05:20:57 |
Message-ID: | 3F94C239.3070601@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
How do I use a schema-qualified name in obj_description? Or is this a
nsty little bug?
Chris
test2=# create schema myschema;
CREATE SCHEMA
test2=# create table myschema.pg_class (a int4);
CREATE TABLE
test2=# select oid from pg_catalog.pg_class where
oid='myschema.pg_class'::regclass;
oid
---------
1475161
(1 row)
test2=# select obj_description('1475161', 'pg_class');
obj_description
-----------------
(1 row)
test2=# select obj_description('1475161', 'pg_catalog.pg_class');
obj_description
-----------------
(1 row)
test2=# set search_path to myschema, pg_catalog;
SET
test2=# select obj_description('1475161', 'pg_class');
ERROR: Attribute "relname" not found
test2=# select obj_description('1475161', 'pg_catalog.pg_class');
ERROR: Attribute "relname" not found
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2003-10-21 05:42:16 | Re: obj_description problems? |
Previous Message | Lauri Pietarinen | 2003-10-21 04:57:31 | Re: Dreaming About Redesigning SQL |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2003-10-21 05:42:16 | Re: obj_description problems? |
Previous Message | Tom Lane | 2003-10-21 04:33:04 | Re: AIX port current |