Re: User functions not displayed by \df

Strange, looks like \df doesn't show functions that return the type
'Opaque'?! How do I view those type of function returns?

Thank You.

On Tue, 2002-10-29 at 14:31, Hadley Willan wrote:
> 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
>
--
Hadley Willan > Systems Development > Deeper Design Limited.
hadley(at)deeper(dot)co(dot)nz > www.deeperdesign.com > +64 (21) 28 41 463