diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-04-30 21:01:52 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-04-30 21:01:52 +0000 |
commit | 936afc8a4b6483b2e77f35cd089979dad8c8830f (patch) | |
tree | 2b97cd05a75aae0a3152409ff2ea6a647d681046 | |
parent | 1e4f34f3099cad3a0860f4ec3762e2a5a5f86dfa (diff) | |
download | postgresql-936afc8a4b6483b2e77f35cd089979dad8c8830f.tar.gz postgresql-936afc8a4b6483b2e77f35cd089979dad8c8830f.zip |
Fix obj_description() and col_description() functions to work reliably
in presence of schemas.
-rw-r--r-- | src/include/catalog/pg_proc.h | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/include/catalog/pg_proc.h b/src/include/catalog/pg_proc.h index 35aee3f4342..17f081049f0 100644 --- a/src/include/catalog/pg_proc.h +++ b/src/include/catalog/pg_proc.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: pg_proc.h,v 1.234 2002/04/26 01:24:08 tgl Exp $ + * $Id: pg_proc.h,v 1.235 2002/04/30 21:01:52 tgl Exp $ * * NOTES * The script catalog/genbki.sh reads this file and generates .bki @@ -1493,9 +1493,9 @@ DESCR("date difference preserving months and years"); DATA(insert OID = 1200 ( reltime PGNSP PGUID 12 f t f t f i 1 703 "23" 100 0 0 100 int4reltime - _null_ )); DESCR("convert int4 to reltime"); -DATA(insert OID = 1215 ( obj_description PGNSP PGUID 14 f t f t f s 2 25 "26 19" 100 0 0 100 "select description from pg_description where objoid = $1 and classoid = (select oid from pg_class where relname = $2) and objsubid = 0" - _null_ )); +DATA(insert OID = 1215 ( obj_description PGNSP PGUID 14 f t f t f s 2 25 "26 19" 100 0 0 100 "select description from pg_description where objoid = $1 and classoid = (select oid from pg_class where relname = $2 and relnamespace = PGNSP) and objsubid = 0" - _null_ )); DESCR("get description for object id and catalog name"); -DATA(insert OID = 1216 ( col_description PGNSP PGUID 14 f t f t f s 2 25 "26 23" 100 0 0 100 "select description from pg_description where objoid = $1 and classoid = (select oid from pg_class where relname = \'pg_class\') and objsubid = $2" - _null_ )); +DATA(insert OID = 1216 ( col_description PGNSP PGUID 14 f t f t f s 2 25 "26 23" 100 0 0 100 "select description from pg_description where objoid = $1 and classoid = \'pg_catalog.pg_class\'::regclass and objsubid = $2" - _null_ )); DESCR("get description for table column"); DATA(insert OID = 1217 ( date_trunc PGNSP PGUID 12 f t f t f i 2 1184 "25 1184" 100 0 0 100 timestamptz_trunc - _null_ )); |