User functions not displayed by \df

From: Hadley Willan <hadley(dot)willan(at)deeper(dot)co(dot)nz>
To: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: User functions not displayed by \df
Date: 2002-10-29 01:31:06
Message-ID: 1035855066.12891.26.camel@orac.area51.deeper.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I was working on a database, and then I decided to cut across to a new
version and import what I wanted manually. I created my new database and
am now bringing across what I want from my .sql text files. These files
tend to contain a table definition and any triggers and associated
functions.

However, in my new database, if I copy a function definition from my
editor and paste it into the terminal window, it succeeds in creating
it, and it works, but when I do a \df it's not shown?!

If I type a new function in by hand into the terminal window, it shows
up?!

However, once the "ghost" function exists, even retyping it by hand does
make it show up in the \df. Even dropping it and recreating it by hand
does not make it show up.

I've also tried piping the function in via the CLI. Again, it gets
created but I still can't see it.

Also, I've logged in as the "postgres" user and they can't see the
functions as well. But they work?!

I'm a bit confused as to why this functionality has changed and what it
is that I may be doing/done wrong?

Thanks.
--
Hadley Willan > Systems Development > Deeper Design Limited.
hadley(at)deeper(dot)co(dot)nz > www.deeperdesign.com > +64 (21) 28 41 463

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hadley Willan 2002-10-29 01:41:42 Re: User functions not displayed by \df
Previous Message Medi Montaseri 2002-10-29 01:12:42 Re: newbie question for return date