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(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!