Re: Problem displaying functions and views in 7.1b3

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hiroshi Inoue <Inoue@tpf.co.jp>
Cc: teo@flex.ro, pgsql-bugs@postgresql.org
Date: 2001-02-08T02:12:51Z
Lists: pgsql-bugs
Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> Tom Lane wrote:
>> Uh, has it ever done differently?  \df certainly appears to me to list
>> all functions in 7.0.*.

> There's the following code in src/bin/pgaccess/lib/mainlib.tcl
>                 wpg_select $CurrentDB "select proname from pg_proc where
> oid>$maxim order by proname" rec {
> where maxim(the oid of "template1" database) is 1 in 7.1.

Okay, so pgaccess has got a behavior change ... but the bug report was
about psql, or so I thought.

We can easily change pgaccess to do this correctly for 7.1, but then it
will fail completely on older releases (there was no datlastsysoid column
in pg_database before).  Is backward compatibility a design concern for
pgaccess, or not?

			regards, tom lane