Re: BUG #5926: information schema dtd_identifier for element_types, columns, parameters views inconsistent

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Susanne Ebrecht <susanne(at)2ndQuadrant(dot)com>, Ingmar Brouns <swingi(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5926: information schema dtd_identifier for element_types, columns, parameters views inconsistent
Date: 2011-06-08 17:38:00
Message-ID: 1307554680.9604.0.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-docs

On ons, 2011-06-08 at 11:09 -0400, Tom Lane wrote:
> The omission of collection_type_identifier from the docs is clearly a
> doc bug. However, it looks to me like you've identified an error in the
> view definition, not only a doc bug. I think the values of the
> dtd_identifier and collection_type_identifier columns are swapped, ie,
> we ought to be prepending 'a' to the collection_type_identifier not the
> dtd_identifier. As far as I can tell from the spec, dtd_identifier
> ought to be the identifier of the element type, while
> collection_type_identifier should be a made-up identifier for the array
> type. That would make the sample query given in the docs correct.

Yes, we need to switch those two columns around and change the
documentation.

> If my analysis is correct, we really ought to try to fix this in time
> for beta2, since there's no way to fix it without a forced initdb.

I can take care of this later today.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2011-06-08 21:43:27 Re: BUG #5926: information schema dtd_identifier for element_types, columns, parameters views inconsistent
Previous Message Tom Lane 2011-06-08 15:09:27 Re: BUG #5926: information schema dtd_identifier for element_types, columns, parameters views inconsistent

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2011-06-08 21:43:27 Re: BUG #5926: information schema dtd_identifier for element_types, columns, parameters views inconsistent
Previous Message Tom Lane 2011-06-08 15:09:27 Re: BUG #5926: information schema dtd_identifier for element_types, columns, parameters views inconsistent