Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2012
    Posts
    30

    Unanswered: How to install the "tablefunct" on Postgres 8.4?

    Hi to All,

    I am working on Postgres 8.4 on linux,

    If I type the command:

    Code:
    SELECT *
    FROM crosstab(
      'select rowid, attribute, value
       from ct
       where attribute = ''att2'' or attribute = ''att3''
       order by 1,2')
    AS ct(row_name text, category_1 text, category_2 text, category_3 text);
    i see this error message:

    Code:
    ERROR function crosstab(unknown) does not exist
    Could SomeOne indicate the commands in order to tablefunction/install?

    Tanks in advance.
    Gianni Pinna.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    This is described in the manual: PostgreSQL: Documentation: 8.4: Additional Supplied Modules

    Quote Originally Posted by The Manual
    Many modules supply new user-defined functions, operators, or types. To make use of one of these modules, after you have installed the code you need to register the new objects in the database system by running the SQL commands in the .sql file supplied by the module. For example,

    psql -d dbname -f SHAREDIR/contrib/module.sql
    Note that 8.4 is quite old and will be de-supported next year (2014). You should really consider upgrading as soon as possible (for more details see: http://www.postgresql.org/support/versioning/).

    On an up-to-date version, this would be as simple as
    Code:
    create extension tablefunc;
    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
    Dec 2012
    Posts
    30
    Hi Shamman,

    Tommaso D'Aquino The Prince of the Philosophers observes:
    Code:
    ...because the truth about God such as reason could discover, would only be known by a few, and that after a long time, and with the admixture of many errors..
    and from the observation he concludes:

    Code:
    Whereas man's whole salvation, which is in God, depends upon the knowledge of this truth. Therefore, in order that the salvation of men might
    be brought about more fitly and more surely, it was necessary that they should be taught divine truths by divine revelation. It was therefore necessary that besides philosophical science built up by reason, there should be a sacred science learned through revelation.
    For the same observation an for analogy, any teacher as You really are, there should be for the beginners as I am.

    Tanks again for Your precious work.

    Best Rgrds.

    Gianni Pinna.

  4. #4
    Join Date
    Dec 2012
    Posts
    30
    I excuse and I correct the mistake of mine:
    Code:
    Hi Shamman=Hi Shammat

Posting Permissions

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