Thread

  1. fix for psql's \dd version check

    Josh Kupershmidt <schmiddy@gmail.com> — 2011-11-11T23:59:39Z

    Someone (me) didn't get the version check for part of psql's \dd
    command quite right. I was using a 9.2 client on a 9.1 server and got
    this when I ran \dd:
    
    ERROR:  function pg_catalog.pg_opfamily_is_visible(oid) does not exist
    LINE 33:   AND pg_catalog.pg_opfamily_is_visible(opf.oid)
    
    since pg_opfamily_is_visible() is only available for 9.2 and up.
    Attached is a simple fix.
    
    Josh
    
  2. Re: fix for psql's \dd version check

    Robert Haas <robertmhaas@gmail.com> — 2011-11-12T04:34:35Z

    On Fri, Nov 11, 2011 at 6:59 PM, Josh Kupershmidt <schmiddy@gmail.com> wrote:
    > Someone (me) didn't get the version check for part of psql's \dd
    > command quite right. I was using a 9.2 client on a 9.1 server and got
    > this when I ran \dd:
    >
    > ERROR:  function pg_catalog.pg_opfamily_is_visible(oid) does not exist
    > LINE 33:   AND pg_catalog.pg_opfamily_is_visible(opf.oid)
    >
    > since pg_opfamily_is_visible() is only available for 9.2 and up.
    > Attached is a simple fix.
    
    Thanks, committed with some comments.
    
    -- 
    Robert Haas
    EnterpriseDB: http://www.enterprisedb.com
    The Enterprise PostgreSQL Company