Re: [BUGS] bug in date_part() function in 6.5.2, 7.0.2

2000-09-08 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: >> Seems like you could just skip step 3 and call localtime() with fields >> indicating midnight of the specified date. Then use the complete >> localtime result (don't discard any fields) and you should be OK, no? > Pretty sure this won't work, since

Re: [BUGS] bug in date_part() function in 6.5.2, 7.0.2

2000-09-08 Thread Thomas Lockhart
> Seems like you could just skip step 3 and call localtime() with fields > indicating midnight of the specified date. Then use the complete > localtime result (don't discard any fields) and you should be OK, no? OK, I have a solution which involves mktime(). As a side effect, I've stripped some

[BUGS] createuser fails

2000-09-08 Thread pgsql-bugs
Pushkar ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description createuser fails Long Description I am trying to install postgres on windows nt . initdb worked fine , and also the createdb command. But when i run any command like crea

Re: [BUGS] createuser fails

2000-09-08 Thread Peter Eisentraut
[EMAIL PROTECTED] writes: > I am trying to install postgres on windows nt . > initdb worked fine , and also the createdb command. > But when i run any command like createuser etc, i get the > following error > psql: connectDBStart() -- socket() failed: errno=106 > Addresses in the specified fam

[BUGS] Backend crash trying to delete rows

2000-09-08 Thread pgsql-bugs
Andrea Aime ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Backend crash trying to delete rows Long Description Platform: RedHat 6.2, PostgreSQL 7.02 compiled by gcc egcs 2.91.66, running on a PIII 733Mhz, 128 MB RAM, 9 GB SCS