Re: [BUGS] BUG #8143: Backend segmentation fault in pg_trgm

2013-05-10 Thread Joel Roller
That was quick. Applied the 91715e82932665 commit directly against the 9.2.4 pgdg source, fix works great. Test data and the original breaking production queries run fine for me. Thank you very much! -joel On May 9, 2013, at 6:19 PM, Tom Lane wrote: > jrol...@rjobrien.com writes: >> We've

Re: [BUGS] BUG #8143: Backend segmentation fault in pg_trgm

2013-05-09 Thread Tom Lane
jrol...@rjobrien.com writes: > We've come across a specific query and query plan that causes a repeatable > segmentation fault on the postgresql backend. Ah, I see it: gistrescan() is trying to preserve the per-scankey fn_extra values to allow caching, but what it's doing does not work if more tha

[BUGS] BUG #8143: Backend segmentation fault in pg_trgm

2013-05-09 Thread jroller
The following bug has been logged on the website: Bug reference: 8143 Logged by: Joel Roller Email address: jrol...@rjobrien.com PostgreSQL version: 9.2.4 Operating system: Debian 6.0.7 + squeeze-pgdg Description: Howdy. We've come across a specific query and query p