Re: BUG #14601: Alternative support for amcanorder column under pg_am

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: ppoojari(at)erwin(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14601: Alternative support for amcanorder column under pg_am
Date: 2017-03-28 20:48:34
Message-ID: 87o9wl5erv.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>>>>> "ppoojari" == ppoojari <ppoojari(at)erwin(dot)com> writes:

ppoojari> In 9.6 when i tried to use amcanorder column under pg_am it
ppoojari> gives me an error stating column doesnt not exist.

This is not a bug.

ppoojari> Can you please provide me with some information if any
ppoojari> alternative solution is provided for this feature ?

select amname, pg_indexam_has_property(oid, 'can_order') as amcanorder
from pg_am;

See https://www.postgresql.org/docs/9.6/static/functions-info.html#FUNCTIONS-INFO-INDEXAM-PROPS

--
Andrew (irc:RhodiumToad)

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Prajval Poojari 2017-03-28 20:56:39 Re: BUG #14601: Alternative support for amcanorder column under pg_am
Previous Message David G. Johnston 2017-03-28 20:40:48 Re: BUG #14601: Alternative support for amcanorder column under pg_am