I still have the same error. Is there any other way of running the script outside pgAdmin? 2011/3/7 Guillaume Lelarge <guillaume@xxxxxxxxxxxx>: > 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 > -- Å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" -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
