Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2016
    Posts
    2

    Unanswered: How to Install ltree for postgress 9.2

    Hi,

    How to install ltree module for postgres 9.2? I have a old db dump from the 8.2 version which has ltree module used. When I extract the same dump in postgres 9.2 it gives me ltree.sql error. I am new to postgres, Please let me know how to install and use the ltree on 9.2

    Thanks
    laxman

  2. #2
    Join Date
    Nov 2003
    Posts
    2,932
    Provided Answers: 12
    Code:
    create extension ltree;
    More details in the manual: http://www.postgresql.org/docs/curre...extension.html
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Apr 2016
    Posts
    2

    getting error

    Hi,

    Thanks for your reply.. I am getting this error..

    ERROR: could not open extension control file "/usr/share/pgsql/extension/ltree.control": No such file or directory

    Pls suggest.

    Thanks
    laxman

  4. #4
    Join Date
    Nov 2003
    Posts
    2,932
    Provided Answers: 12
    You need to install the postgresql-contrib package.

    How exactly you do that depends on your Linux distribution.

    For details about your Linux distribution see the Postgres homepage: http://www.postgresql.org/download/
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •