| 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: | Whole Thread | Raw Message | 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 |