BUG #14601: Alternative support for amcanorder column under pg_am

On Tue, Mar 28, 2017 at 12:50 PM, <ppoojari@erwin.com> wrote:

The following bug has been logged on the website:

Bug reference: 14601
Logged by: Prajval Poojari
Email address: ppoojari@erwin.com
PostgreSQL version: 9.6.2
Operating system: Win10 64 bit Pro
Description:

Hi
In 9.6 when i tried to use amcanorder column under pg_am it gives me an
error stating column doesnt not exist.
Can you please provide me with some information if any alternative solution
is provided for this feature ?

​The 9.6 documentation page ​for pg_am is a good place to start.

https://www.postgresql.org/docs/9.6/static/catalog-pg-am.html

David J.

Yes David I agree
But the problem occurring is column named amcanorder which was available until 9.5 release is not available in 9.6
So do we have any alternative solution if I want to use that column in 9.6 ?

Get Outlook for iOS<https://aka.ms/o0ukef&gt;
________________________________
From: David G. Johnston <david.g.johnston@gmail.com>
Sent: Tuesday, March 28, 2017 4:16:44 PM
To: Prajval Poojari
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #14601: Alternative support for amcanorder column under pg_am

On Tue, Mar 28, 2017 at 12:50 PM, <ppoojari@erwin.com<mailto:ppoojari@erwin.com>> wrote:
The following bug has been logged on the website:

Bug reference: 14601
Logged by: Prajval Poojari
Email address: ppoojari@erwin.com<mailto:ppoojari@erwin.com>
PostgreSQL version: 9.6.2
Operating system: Win10 64 bit Pro
Description:

Hi
In 9.6 when i tried to use amcanorder column under pg_am it gives me an
error stating column doesnt not exist.
Can you please provide me with some information if any alternative solution
is provided for this feature ?

​The 9.6 documentation page ​for pg_am is a good place to start.

https://www.postgresql.org/docs/9.6/static/catalog-pg-am.html

David J.

On Tue, Mar 28, 2017 at 1:32 PM, Prajval Poojari <ppoojari@erwin.com> wrote:

Yes David I agree
But the problem occurring is column named amcanorder which was available
until 9.5 release is not available in 9.6
So do we have any alternative solution if I want to use that column in 9.6
?

You agree with what?

The table mentioned in the page I linked to has this:

pg_indexam_has_property(am_oid, prop_name) boolean test whether an index
access method has a specified property

Definitions of am_oid and prop_name and present later on the same page.

Whatever it is you are doing will need version detection logic and a
different query for the newer stuff versus the older stuff.

David J.​

"ppoojari" == ppoojari <ppoojari@erwin.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)

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Thanks Guys.

Regards,
Prajval Poojari

-----Original Message-----
From: Andrew Gierth [mailto:andrew@tao11.riddles.org.uk]
Sent: Tuesday, March 28, 2017 4:49 PM
To: Prajval Poojari <ppoojari@erwin.com>
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #14601: Alternative support for amcanorder column under pg_am

"ppoojari" == ppoojari <ppoojari@erwin.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)

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs