Re: Have psql display names and OUT/INOUT in \df output

On Sun, Jul 16, 2006 at 12:21:12AM -0700, Neil Conway wrote:
> On Sat, 2006-07-15 at 23:16 -0700, David Fetter wrote:
> > Anyhow, please find enclosed the context-style diff.
>
> How carefully did you test this?

Not enough.  Here's the latest.

> postgres=# \df abc
>                    List of functions
>  Schema | Name | Result data type | Argument data types
> --------+------+------------------+---------------------
>  public | abc  | integer          | a integer,b integer
> (1 row)
>
> (The argument list should be separated by both a comma and whitespace.)
>
> postgres=# create or replace function xyz(inout a int, inout int)
> returns record as 'select (1, 2);' language sql;
> CREATE FUNCTION
> postgres=# \df xyz
>                           List of functions
>  Schema | Name | Result data type |       Argument data types
> --------+------+------------------+----------------------------------
>  public | xyz  | record           |  INOUT a integer, INOUT  integer
> (1 row)

These are now fixed.

> (Spurious whitespace for the unnamed INOUT parameter.)
>
> You need to schema-qualify references to builtin functions, to avoid
> accidentally using functions of the same name that appear earlier in
> the user's search path.

I don't understand what you mean here.  The schema name comes with
both versions of \df, just as it did before.

Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!