Thread: psql: server version check for \dO

psql: server version check for \dO

From
Josh Kupershmidt
Date:
Hi all,

I think psql's \dO command is missing the server version check which
similar commands such as \dx use. Right now \dO errors out with:

test=# \dO
ERROR:  relation "pg_catalog.pg_collation" does not exist

when talking to servers older than 9.1, which don't have pg_collation.
Simple patch for listCollations() attached.

Josh

Attachment

Re: psql: server version check for \dO

From
Magnus Hagander
Date:
On Thu, May 10, 2012 at 7:09 AM, Josh Kupershmidt <schmiddy@gmail.com> wrote:
> Hi all,
>
> I think psql's \dO command is missing the server version check which
> similar commands such as \dx use. Right now \dO errors out with:
>
> test=# \dO
> ERROR:  relation "pg_catalog.pg_collation" does not exist
>
> when talking to servers older than 9.1, which don't have pg_collation.
> Simple patch for listCollations() attached.

Indeed. Thanks, applied and backpatched to 9.1.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/