Re: User functions not displayed by \df

Okay, me again. I was readin the psql source and noticed that (df)
describeFunction explicitly excludes return type 0 which just happens to
be opaque. I did a select on pg_proc and the functions that had the
return type 0 happened to be returns OPAQUE.

Does anybody know why this would be the case?

So problem solved as I now know why my OPAQUE return type functions are
vanishing and I have a work around, sorry to bother.

H

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