From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Unable to create function via psql |
Date: | 2011-03-07 09:31:21 |
Message-ID: | 4D74A5E9.7070906@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Le 07/03/2011 09:17, Lukasz Brodziak a écrit :
> Hello,
>
> I have a problem with creating function through script ran in psql.
> I'm running the script AdminPack.sql from the contrib package using
> this statement:
> sudo su postgres -c psql MyDB < /usr/share/postgresql/8.2/contrib/adminpack.sql
>
> Script performs without problem yet when I log into my software I get
> the error that pg_file_lenght does not exists. Opening the script in
> pgAdmin and hitting F5 creates the function and enables logging into
> the program without error. Can anyone help me with running the script
> correctly through shell.
You need to execute the script in the postgres database, not the MyDB
database.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Lukasz Brodziak | 2011-03-07 10:39:09 | Re: Unable to create function via psql |
Previous Message | Lukasz Brodziak | 2011-03-07 08:17:52 | Unable to create function via psql |