Thread

  1. psql: server version check for \dO

    Josh Kupershmidt <schmiddy@gmail.com> — 2012-05-10T05:09:27Z

    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
    
  2. Re: psql: server version check for \dO

    Magnus Hagander <magnus@hagander.net> — 2012-05-10T07:13:45Z

    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/