Re: [BUGS] Deadlock or other hang while vacuuming?

2004-11-08 Thread Tom Lane
Craig Ruff <[EMAIL PROTECTED]> writes: > I have an annoying problem with some kind of a hang or deadlock triggered > sometimes when running a vacuum on a table with a pair of read only > cursors enumerating different subsets of rows of the same table. I believe that if VACUUM wants to delete a tup

Re: [BUGS] Possible bug: pg_hba.conf file

2004-11-08 Thread Gaetano Mendola
Tom Lane wrote: ! maskl = (0xUL << (32 - (int) bits)) ! & 0xUL; Is that "& 0xUL" required ? ---(end of broadcast)--- TIP 8: explain analyze i

[BUGS] Deadlock or other hang while vacuuming?

2004-11-08 Thread Craig Ruff
I have an annoying problem with some kind of a hang or deadlock triggered sometimes when running a vacuum on a table with a pair of read only cursors enumerating different subsets of rows of the same table. (Originally, I also could have other queries that modified the table running concurrently, b

Re: [BUGS] Killed backend won't rollback transaction?

2004-11-08 Thread SZŰCS Gábor
Dear Tom, - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> Sent: Friday, November 05, 2004 5:02 PM > SIGTERM on individual backends is not recommended or supported. That explains this. Keeping this policy in mind, I wouldn't qualify this as a bug after all. > FWIW, though, I

Re: [BUGS] error with windows 2003

2004-11-08 Thread Magnus Hagander
> Greetings. > recently i downloaded the postgres version for windows, but > after i installed it in my server, i get the following error: > "server closed the connection unexpectedly this probably > means the server terminated abnormally before or while > processing the request" > > can you he