[BUGS] BUG #3303: Postgresql damages file objects when it grows with more file objects.

2007-05-24 Thread Purusothaman A
The following bug has been logged online: Bug reference: 3303 Logged by: Purusothaman A Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Windows XP Description:Postgresql damages file objects when it grows with more file objects. Details:

[BUGS] BUG #3302: Crash on gist ltree - PANIC: failed to add item to index page

2007-05-24 Thread Cstdenis
The following bug has been logged online: Bug reference: 3302 Logged by: Cstdenis Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: FreeBSD 6.1-RELEASE-p15 Description:Crash on gist ltree - PANIC: failed to add item to index page Details:

[BUGS]

2007-05-24 Thread filipe paiva
I already had done this but it seems the "Store password" function stores the password in a file other than the pgpass.conf because it really stores passwords with or without that file. Can anyone tell me if it is possible to set the "Store password" option in a file? Because if it isn't possi

[BUGS] BUG #3301: explain crashes server on simple (?) query

2007-05-24 Thread Leszek Trenkner
The following bug has been logged online: Bug reference: 3301 Logged by: Leszek Trenkner Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3devel Operating system: Linux (Ubuntu Fiesty 7.04) Description:explain crashes server on simple (?) query Details: When I

Re: [BUGS] BUG #3302: Crash on gist ltree - PANIC: failed to add item to index page

2007-05-24 Thread Teodor Sigaev
CREATE INDEX idx_picture_comments_id_tree_gist ON picture_comments USING gist (id_tree); and the server exited on signal 6 (core dumped) Is it reproducible? Pls, send to me dump of ltree column. ---(end of broadcast)

[BUGS] BUG #3304: win32 build fails, because of wrong include

2007-05-24 Thread
The following bug has been logged online: Bug reference: 3304 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.9 Operating system: Windows 2000 Description:win32 build fails, because of wrong include Details: When you set the ENABLE_THREAD_SAFETY

Re: [BUGS] BUG #3304: win32 build fails, because of wrong include

2007-05-24 Thread Magnus Hagander
[EMAIL PROTECTED] wrote: > The following bug has been logged online: > > Bug reference: 3304 > Logged by: > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.9 > Operating system: Windows 2000 > Description:win32 build fails, because of wrong include > Detail

Re: [BUGS] BUG #3301: explain crashes server on simple (?) query

2007-05-24 Thread Tom Lane
"Leszek Trenkner" <[EMAIL PROTECTED]> writes: > I'll post schema for bug recreation on pgsql-bugs. Yes? regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate s

Re: [BUGS] BUG #3302: Crash on gist ltree - PANIC: failed to add item to index page

2007-05-24 Thread Teodor Sigaev
I haven't been able to reproduce it. I think its a race condition between some of the other processes running at the time. I'm not sure what else was running on it, but the error suggests an insert to me and there may have been a vacuum running (plus there are always plenty of selects running

Re: [BUGS] BUG #3302: Crash on gist ltree - PANIC: failed to add item to index page

2007-05-24 Thread Cstdenis
Teodor Sigaev wrote: CREATE INDEX idx_picture_comments_id_tree_gist ON picture_comments USING gist (id_tree); and the server exited on signal 6 (core dumped) Is it reproducible? Pls, send to me dump of ltree column. I haven't been able to reproduce it. I think its a

Re: [BUGS] BUG #3301: explain crashes server on simple (?) query

2007-05-24 Thread Leszek Trenkner
Tom Lane wrote: > "Leszek Trenkner" <[EMAIL PROTECTED]> writes: >> I'll post schema for bug recreation on pgsql-bugs. > > Yes? > > regards, tom lane Well, I bug appeared on list with a long delay, so in the morning I didn't notice it yet. Database dump that allows me to recreate situation comes

Re: [BUGS] BUG #3301: explain crashes server on simple (?) query

2007-05-24 Thread Tom Lane
Leszek Trenkner <[EMAIL PROTECTED]> writes: > Database dump that allows me to recreate situation comes > attached. It's a really simple query, and today I reproduced the very same > crash on different machine. Fixed, thanks for the report! > It doesn't happen on stock Ubuntu's 8.2 No, this is