[BUGS] atan2 documentation bugs for 7.3 and 7.2

2002-09-05 Thread Bruno Wolff III
In the section on mathematical functions the following is given for atan2: atan2(x, y) inverse tangent of a/x I believe the correct version should either be: atan2(y, x) inverse tangent of y/x or atan2(x, y) inverse tangent of x/y I beleive the documentation was also wrong for 7.2 where it was:

[BUGS] Bug #758: show_planner_stats does not work for new PREPARE calls

2002-09-05 Thread pgsql-bugs
Barry Lind ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description show_planner_stats does not work for new PREPARE calls Long Description I was testing the 7.3 PREPARE functionality. I was using the timing information from show_pars

Re: [BUGS] Schemas not available for pl/pgsql %TYPE....

2002-09-05 Thread Joe Conway
Sean Chittenden wrote: > Not a problem there. I walked around the code for a bit, made a few > hacks to see how things are working, and I can tell you strait up that > if you'd like this by 7.3, it won't be happening from me. <:~) I'm > stretched kinda thin as is and don't think I'll be able to

Re: [BUGS] Schemas not available for pl/pgsql %TYPE....

2002-09-05 Thread Sean Chittenden
> > ::sigh:: Is it me or does it look like all > > of pl/pgsql is schema un-aware (ie, all of the declarations). -sc > > Yeah. The group of routines parse_word, parse_dblword, etc that are > called by the lexer certainly all need work. There are some > definitional issues to think about, too -

Re: [BUGS] Bug #756: suggestion: file with password instead of

2002-09-05 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > OK, next question. Is this something that can be fixed during beta. > > Yeah, I think so --- it's not forcing an initdb, so it won't be too > painful for beta testers. And once we release it will be very hard > to change the defini

Re: [BUGS] Bug #756: suggestion: file with password instead of

2002-09-05 Thread Reinhard Max
On 5 Sep 2002 at 12:33, Rod Taylor wrote: > My understanding is that it's a single password, not a list. > > As such you would probably not want a default, as each database you > connect to will (should?) have a different password. By setting a > default file we may encourage users to use the sa

Re: [BUGS] Bug #756: suggestion: file with password instead of

2002-09-05 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > OK, next question. Is this something that can be fixed during beta. Yeah, I think so --- it's not forcing an initdb, so it won't be too painful for beta testers. And once we release it will be very hard to change the definition of the feature; better

Re: [BUGS] Bug #756: suggestion: file with password instead of

2002-09-05 Thread Rod Taylor
> > My understanding is that it's a single password, not a list. > > It isn't a single password. It is a file containing one password per > line with pattern matching. Oh, well in that case it should probably be a default spot in the home directory. ---(end of broadcas

Re: [BUGS] pg-config --includedir-server

2002-09-05 Thread Tom Lane
elein <[EMAIL PROTECTED]> writes: > Per docs 12.5.6 Writing Code I ran pg_config --includedir-server to verify > the location on the C include files. It said /usr/local/pgsql/include/server. > Neither the files nor the directory were there, however. Sounds like you did not do "make install-all-h

Re: [BUGS] Bug #756: suggestion: file with password instead of

2002-09-05 Thread Bruce Momjian
Rod Taylor wrote: > On Thu, 2002-09-05 at 12:14, Bruce Momjian wrote: > > Rod Taylor wrote: > > > On Thu, 2002-09-05 at 05:13, Reinhard Max wrote: > > > > On 4 Sep 2002 at 12:48, Rod Taylor wrote: > > > > > > > > > This item: > > > > > Add file to hold passwords using PGPASSWORDFILE environment v

Re: [BUGS] Bug #756: suggestion: file with password instead of

2002-09-05 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > >>> Is there a default file name like ~/.pgpassword so that this feature > >>> can be used without setting yet another environment variable? > > > Is there a good reason for a default for this? > > Well, most of the other packages I c

Re: [BUGS] Bug #756: suggestion: file with password instead of

2002-09-05 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: >>> Is there a default file name like ~/.pgpassword so that this feature >>> can be used without setting yet another environment variable? > Is there a good reason for a default for this? Well, most of the other packages I can think of have hard-wired as

Re: [BUGS] Bug #756: suggestion: file with password instead of

2002-09-05 Thread Rod Taylor
On Thu, 2002-09-05 at 12:14, Bruce Momjian wrote: > Rod Taylor wrote: > > On Thu, 2002-09-05 at 05:13, Reinhard Max wrote: > > > On 4 Sep 2002 at 12:48, Rod Taylor wrote: > > > > > > > This item: > > > > Add file to hold passwords using PGPASSWORDFILE environment variable > > > > > > > > Has been

[BUGS] pg-config --includedir-server

2002-09-05 Thread elein
PostgreSQL 7.2.2 SuSe 7.3 This is a new installation not an update. (New machine ;-) If this is a bug it probably will only affect new/clean installations of 7.2.* Per docs 12.5.6 Writing Code I ran pg_config --includedir-server to verify the location on the C include files. It said /usr/loca

Re: [BUGS] Bug #756: suggestion: file with password instead of

2002-09-05 Thread Bruce Momjian
Rod Taylor wrote: > On Thu, 2002-09-05 at 05:13, Reinhard Max wrote: > > On 4 Sep 2002 at 12:48, Rod Taylor wrote: > > > > > This item: > > > Add file to hold passwords using PGPASSWORDFILE environment variable > > > > > > Has been completed, and will be a part of the 7.3 release. > > > > Is the

Re: [BUGS] Bug #756: suggestion: file with password instead of

2002-09-05 Thread Rod Taylor
On Thu, 2002-09-05 at 05:13, Reinhard Max wrote: > On 4 Sep 2002 at 12:48, Rod Taylor wrote: > > > This item: > > Add file to hold passwords using PGPASSWORDFILE environment variable > > > > Has been completed, and will be a part of the 7.3 release. > > Is there a default file name like ~/.pgpas

Re: [BUGS] Bug #756: suggestion: file with password instead of

2002-09-05 Thread Reinhard Max
On 4 Sep 2002 at 12:48, Rod Taylor wrote: > This item: > Add file to hold passwords using PGPASSWORDFILE environment variable > > Has been completed, and will be a part of the 7.3 release. Is there a default file name like ~/.pgpassword so that this feature can be used without setting yet anothe