Unable to create function via psql

From: Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Unable to create function via psql
Date: 2011-03-07 08:17:52
Message-ID: AANLkTim4r6Hra0vHUOC8bnF1qA6YqreQFcs3PyiaDnkv@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.
--
Łukasz Brodziak
"What if everyting around You isn't quite as it seems,
What if all the world You think You know is an inelaborate dream
When You look at Your reflection is that all you want it to be
What if You could look right through the cracks
Would You find Yourself...... Find Yourself afraid to see"

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2011-03-07 09:31:21 Re: Unable to create function via psql
Previous Message Devrim GÜNDÜZ 2011-03-07 07:12:22 Re: WAL archiving between 32 and 64 bit