Horton

Re: psql: server version check for \dO

Magnus Hagander <magnus@hagander.net>

View thread
From: Magnus Hagander <magnus@hagander.net>
To: Josh Kupershmidt <schmiddy@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2012-05-10T07:13:45Z
Lists: pgsql-hackers 
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/