Re: Problem displaying functions and views in 7.1b3

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: teo(at)flex(dot)ro, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Problem displaying functions and views in 7.1b3
Date: 2001-02-08 04:34:12
Message-ID: 3A8221C4.68044940@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane wrote:
>
> Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)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.
>

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-02-08 04:39:51 Re: Problem displaying functions and views in 7.1b3
Previous Message Tom Lane 2001-02-08 02:12:51 Re: Problem displaying functions and views in 7.1b3