Re: [BUGS] BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767)

[Dave Page <dpage(at)postgresql(dot)org>]

Tom Lane wrote:
> > We use the data in various UI elements as well as for reverse
> > engineering the SQL - it's easier to get it broken down than to parse it
> > back out of the complete definition.
>
> Seems like all the more argument for having functions that extract
> single pieces of information, rather than several pieces (especially
> if some pieces get left off when default).

Well it might well have been if the pgAdmin code didn't already work and 
it wasn't so close to release :-)

> For the moment I've reverted pg_get_indexdef() to its prior behavior
> of printing only the index column key or expression when colno!=0.
> We can look at having another function to do the other thing in 8.4.

Thanks.

/D