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

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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Dave Page <dpage(at)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, NikhilS <nikkhils(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Boonchai <boonchai(at)xsidekick(dot)com>, pgsql-bugs(at)postgresql(dot)org, pgadmin-support(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767)
Date: 2008-03-07 20:39:13
Message-ID: 200803072039.m27KdDd13416@momjian.us (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-bugs
Added to TODO:

* Add a function like pg_get_indexdef() that report more detailed index
  information

  http://archives.postgresql.org/pgsql-bugs/2007-12/msg00166.php


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

Dave Page wrote:
> 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

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

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

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2008-03-07 21:09:10
Subject: Re: [PATCH] Don't bail with legitimate -N/-B options
Previous:From: Tom LaneDate: 2008-03-07 20:31:08
Subject: Re: BUG #4019: Comparison of user defined domain doesn't work

pgadmin-support by date

Next:From: Michael EschweilerDate: 2008-03-07 22:58:48
Subject: Re: Complete breakdown of pgadmin when trying to connect to server or modify properties of tables of views
Previous:From: RuiDCDate: 2008-03-07 20:29:58
Subject: Re: Compiling PgAdmin 1.8.x on Debian LennyAMD64?

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