"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
pgsql-bugs by date
|Next:||From: nicola75ss||Date: 2011-04-24 18:17:50|
|Subject: BUG #5993: pg_size_pretty overflow|
|Previous:||From: Bryant, Alex||Date: 2011-04-22 19:29:16|
|Subject: Upgrading from 1.10 to 1.12 - cannot set up server|