Re: [BUGS] BUG #6629: Creating a gist index fails with "too many LWLocks taken"

2012-05-07 Thread tom Tom
Nope, this was just a benchmark script that caused this, any sane person would use an intbig index instead I guess. A better error message would be nice though, I was pretty confused when this happened. This can also bring down postgresql - it happens occasionally and causes the server to terminat

Re: [BUGS] BUG #7550: NULL result when coercing a subquery result into an array

2012-09-17 Thread tom Tom
Ok, I will try. I apologize, I made a mistake in the original post: 'J. P. Bickella' returns the correct array and 'J. P. Bickell' returns NULL. That's what you get for posting in a hurry! This is the first time I have run this query, so I don't know if it affects previous versions. ~Tom On Mon,

Re: [BUGS] BUG #7550: NULL result when coercing a subquery result into an array

2012-09-18 Thread tom Tom
ise I guess its not that serious or interesting. Out of interest is there a debug build I can install or any steps I can take to investigate this? I'm just pretty curious as to why this would be occurring. ~Tom On Mon, Sep 17, 2012 at 9:44 PM, tom Tom wrote: > Ok, I will try. I apologize, I m