Re: Unable to create function via psql

Yes. The only DBs on the server are both templates, postgres and MyDB.
Still don't why the problem with the function occurs only when the
script is ran through psql and not through pgAdmin.

2011/3/7 Guillaume Lelarge <guillaume(at)lelarge(dot)info>:
> Le 07/03/2011 11:54, Lukasz Brodziak a écrit :
>> Here it is: http://img69.imageshack.us/i/errorjn.png/
>>
>> Again, when I perform AdminPack.sql in pgAdmin I don't get the error.
>>
>
> You don't do the same thing. If "performing" adminpack.sql is executing
> it, you also don't have an error with psql when you execute it. At
> least, the error message displayed has nothing to do with executing the
> adminpack SQL script.
>
> To get back to your error message, it simply says that the
> pg_file_length(text) function doesn't exist in the database your tool is
> connected too. So, first, you need to make sure that your tool connects
> to the database where you added the functions (IOW, where you executed
> the adminpack script).
>
>
> --
> 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"