Re: Make & Install contrib/tablefunc Problems - Mailing list pgsql-general

From Stefan Schwarzer
Subject Re: Make & Install contrib/tablefunc Problems
Date
Msg-id 0A55EB67-C5B9-426D-BFDC-AA726A6D5019@grid.unep.ch
Whole thread Raw
In response to Re: Make & Install contrib/tablefunc Problems  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Make & Install contrib/tablefunc Problems  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
>> But when I do this I get this error message:
>
>>     Makefile:17: ../../src/Makefile.global: No such file or directory
>>     Makefile:18: /contrib/contrib-global.mk: No such file or directory
>>     make: *** No rule to make target `/contrib/contrib-global.mk'.
>> Stop.
>
>> What is the problem? What can/should I do?
>
> You need to re-run configure in the top level of the distribution
> tree.
> Be sure to use the same configure flags as before (pg_config will
> remind
> you what they were).

Thanks a lot for the quick reaction. Did this, but now - I am not
really strong in postgres management - I get this:

    $ psql -U xxx my_database < tablefunc.sql
    SET
    ERROR:  permission denied for language c

Guess I'd need to do this as/with postgres user/role. But really not
sure how this goes. Thought it should be something like this:

    sudo su - postgres -c '/usr/local/pgsql/bin/pgsql' < tablefunc.sql

But that's no correct.

Thanks for any advice.

Attachment

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: not officially documented use of setweight??
Next
From: xu fei
Date:
Subject: Re: FTS uses "tsquery" directly in the query