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

2001-02-12 Thread Constantin Teodorescu
- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Hiroshi Inoue" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, February 08, 2001 4:12 AM Subject: Re: [BUGS] Problem displaying functions and views

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

2001-02-07 Thread Tom Lane
Hiroshi Inoue <[EMAIL PROTECTED]> writes: > How about the following though the result is different from > datlastsysoid ? > select max(oid) from pg_database where datname like 'template%'; Too lax --- suppose someone makes a database named 'template3' ? Even if we restricted the pattern to 't

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

2001-02-07 Thread 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

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

2001-02-07 Thread Tom Lane
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 wh

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

2001-02-07 Thread Hiroshi Inoue
Tom Lane wrote: > > > When one displays functions, one gets the opposite ... the command lists > > *all* functions, including all builtins, not just user-defined > > functions. > > Uh, has it ever done differently? \df certainly appears to me to list > all functions in 7.0.*. > There's the fo

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

2001-02-07 Thread Tom Lane
[EMAIL PROTECTED] writes: > I've noticed a problem displaying Functions and Views via PSQL in > 7.1b3. When one attempts to display views (\dv), one gets nothing. This is a symptom of using 7.0.* or older psql with current server. > When one displays functions, one gets the opposite ... the co

[BUGS] Problem displaying functions and views in 7.1b3

2001-02-07 Thread pgsql-bugs
() reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Problem displaying functions and views in 7.1b3 Long Description BUG REPORT Version: 7.1 beta 3 Platform: SuSE Linux 7.0 Installation: Mixed; 7.0.3 & 7.1 beta parallel install Urgency: Cosmeti