Re: database introspection error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "Jon Nelson" <jnelson+pgsql(at)jamponi(dot)net>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: database introspection error
Date: 2011-04-23 19:53:48
Message-ID: 4473.1303588428@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> Jon Nelson <jnelson+pgsql(at)jamponi(dot)net> wrote:
>> Would the following query be more (most?) correct, assuming the
>> oid of the table is known?

> It doesn't seem to work for indexes on expressions.

Depends on what you mean by "work". If you're looking for attributes
that are used as simple index columns, it's probably fine. If you want
to also find attributes that are used in index expressions, you might
want to make use of a join through pg_depend. One disadvantage of
pg_depend is that it doesn't help for system catalog indexes (because
indexes built at bootstrap time aren't included in pg_depend) --- not
sure if that is something SQLAlchemy cares about.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message nicola75ss 2011-04-24 18:17:50 BUG #5993: pg_size_pretty overflow
Previous Message Bryant, Alex 2011-04-22 19:29:16 Upgrading from 1.10 to 1.12 - cannot set up server