pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Lukasz Brodziak <lukasz.brodziak@gmail.com>
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: pgsql-admin@postgresql.org
Subject: Re: Unable to create function via psql
Date: Mon, 7 Mar 2011 12:55:20 +0100
Message-ID: <AANLkTikT34dpTMPt5AS4aLsrENADUh5gbZEFRjqcdSYs@mail.gmail.com> (raw)
In-Reply-To: <4D74BC03.2020101@lelarge.info>
References: <AANLkTim4r6Hra0vHUOC8bnF1qA6YqreQFcs3PyiaDnkv@mail.gmail.com>
	<4D74A5E9.7070906@lelarge.info>
	<AANLkTim2hbGOQ20zZGhyie+Rh60LqWBa8cgDHzhE=mW3@mail.gmail.com>
	<4D74B72E.20405@lelarge.info>
	<AANLkTik0jqS+RPmKXUmSzZO2mKqYnTGG-uiXDB6Qvaju@mail.gmail.com>
	<4D74BC03.2020101@lelarge.info>

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@lelarge.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"



view thread (9+ messages)  latest in thread

Message-ID: <AANLkTikT34dpTMPt5AS4aLsrENADUh5gbZEFRjqcdSYs@mail.gmail.com>
Permalink:  ../AANLkTikT34dpTMPt5AS4aLsrENADUh5gbZEFRjqcdSYs@mail.gmail.com/
Also on:    postgresql.org/message-id/AANLkTikT34dpTMPt5AS4aLsrENADUh5gbZEFRjqcdSYs@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: lukasz.brodziak@gmail.com, guillaume@lelarge.info
  Subject: Re: Unable to create function via psql
  In-Reply-To: <AANLkTikT34dpTMPt5AS4aLsrENADUh5gbZEFRjqcdSYs@mail.gmail.com>
  References: <AANLkTim4r6Hra0vHUOC8bnF1qA6YqreQFcs3PyiaDnkv@mail.gmail.com> <4D74A5E9.7070906@lelarge.info> <AANLkTim2hbGOQ20zZGhyie+Rh60LqWBa8cgDHzhE=mW3@mail.gmail.com> <4D74B72E.20405@lelarge.info> <AANLkTik0jqS+RPmKXUmSzZO2mKqYnTGG-uiXDB6Qvaju@mail.gmail.com> <4D74BC03.2020101@lelarge.info> <AANLkTikT34dpTMPt5AS4aLsrENADUh5gbZEFRjqcdSYs@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox