Skip site navigation (1) Skip section navigation (2)

Re: Problem displaying functions and views in 7.1b3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
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 02:12:51
Message-ID: 10415.981598371@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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.

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

In response to

Responses

pgsql-bugs by date

Next:From: Hiroshi InoueDate: 2001-02-08 04:34:12
Subject: Re: Problem displaying functions and views in 7.1b3
Previous:From: Jake NewrenDate: 2001-02-08 01:53:27
Subject: View refuses to work after system reboot

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group