Re: [PATCHES] WIP - MSVC build script replacements

2007-09-18 Thread Andrew Dunstan
Here are the latest versions. ECPG regression still isn't working, but then it isn't on my machine with the .bat file either. I don't know yet if that's my fault or the script's or something else. I'm inclined to commit these without changing the .bat files in the first instance, so people c

[PATCHES] Incorrect results from corr()

2007-09-18 Thread Neil Conway
The builtin corr() aggregate doesn't produce the correct results in some circumstances. Per the SQL spec, corr(x, y) is defined as equivalent to covar_pop(x, y) / (stddev_pop(x) * stddev_pop(y)). postgres=# create table t1 (x float8, y float8); CREATE TABLE postgres=# copy t1 from stdin with csv;

Re: [PATCHES] HOT version 18

2007-09-18 Thread Jaime Casanova
On 9/18/07, Zoltan Boszormenyi <[EMAIL PROTECTED]> wrote: > Hi, > > Pavan Deolasee írta: > > > > > > On 9/18/07, *Jaime Casanova* <[EMAIL PROTECTED] > > > wrote: > > > > > > > > this sql scripts make current cvs + patch to crash with this message > > in the logs: >

[PATCHES] Show login privilege in psql \du command

2007-09-18 Thread Bernd Helmle
Please find attached a tiny patch which adds a "Login" field to the \du command, displaying wether a role has the LOGIN privilege granted or not. I found this useful, since you have to query the system catalog directly to find out which role is permitted to login. -- Thanks

Re: [PATCHES] HOT version 18

2007-09-18 Thread Zoltan Boszormenyi
Hi, Pavan Deolasee írta: On 9/18/07, *Jaime Casanova* <[EMAIL PROTECTED] > wrote: this sql scripts make current cvs + patch to crash with this message in the logs: Can you please check if the attached patch fixes the issue for you ? It sets t_tableOid b