Re: [BUGS] Problem displaying functions and views in 7.1b3

[Hiroshi Inoue]

Tom Lane wrote: > > Hiroshi Inoue <[EMAIL PROTECTED]> 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. > Similar bug reports have been floating around ODBC, pgaccess, psql etc and so people seem to be confused. > 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? > How about the following though the result is different from datlastsysoid ? select max(oid) from pg_database where datname like 'template%'; Regards, Hiroshi Inoue