Skip site navigation (1) Skip section navigation (2)

Re: [BUGS] BUG #2942: information_schema.element_types: documentation error

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Kirill Simonov <xi(at)gamma(dot)dn(dot)ua>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [BUGS] BUG #2942: information_schema.element_types: documentation error
Date: 2007-02-20 18:48:12
Message-ID: 200702201848.l1KImCL17355@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
Thanks.  I have updated the documentation with the attached patch, and
backpatched it to 8.2.X.

---------------------------------------------------------------------------

Kirill Simonov wrote:
> 
> The following bug has been logged online:
> 
> Bug reference:      2942
> Logged by:          Kirill Simonov
> Email address:      xi(at)gamma(dot)dn(dot)ua
> PostgreSQL version: 8.2
> Operating system:   Linux
> Description:        information_schema.element_types: documentation error
> Details: 
> 
> The page
> http://www.postgresql.org/docs/8.2/interactive/infoschema-element-types.html
> 
> contains obsolete information.
> 
> The example query
> SELECT c.column_name, c.data_type, e.data_type AS element_type
> FROM information_schema.columns c LEFT JOIN information_schema.element_types
> e
>      ON ((c.table_catalog, c.table_schema, c.table_name, 'TABLE',
> c.dtd_identifier)
>        = (e.object_catalog, e.object_schema, e.object_name, e.object_type,
> e.array_type_identifier))
> WHERE c.table_schema = '...' AND c.table_name = '...'
> ORDER BY c.ordinal_position;
> fails with ERROR:  column e.array_type_identifier does not exist.
> 
> The fix is to replace 'e.array_type_identifier' with e'dtd_identifier'.
> 
> The column array_type_identifier described in the Table 32-17 does not
> exists.
> 
> The column dtd_identifier, which is described as "This is currently not
> useful.", should have he description of the former array_type_identifier
> column.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>        message can get through to the mailing list cleanly

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

Attachment: /rtmp/diff
Description: text/x-diff (2.5 KB)

In response to

pgsql-bugs by date

Next:From: Matt SmithDate: 2007-02-20 23:50:36
Subject: BUG #3041: Universal Binary Support in Configure
Previous:From: Dreas NielsenDate: 2007-02-20 18:39:55
Subject: BUG #3040: Domain type handling change in 8.2.2 breaks declarations

pgsql-patches by date

Next:From: Andrew DunstanDate: 2007-02-20 19:38:33
Subject: Re: Warning about LISTEN names
Previous:From: Neil ConwayDate: 2007-02-20 18:37:06
Subject: Re: Warning about LISTEN names

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group