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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
