Re: [BUGS] BUG #6092: specific casting required for gist indexing of bigint

2011-07-06 Thread Tom Lane
Jeff Frost writes: > On 07/05/11 17:06, Tom Lane wrote: >> "Jeff Frost" writes: >>> Ran into a situation with a customer who is using the btree_gist contrib >>> module to allow combined index of some tsearch data and two other columns. >>> One of these other columns is a bigint field. I noticed

Re: [BUGS] BUG #6092: specific casting required for gist indexing of bigint

2011-07-06 Thread Jeff Frost
On 07/05/11 17:06, Tom Lane wrote: > "Jeff Frost" writes: >> Ran into a situation with a customer who is using the btree_gist contrib >> module to allow combined index of some tsearch data and two other columns. >> One of these other columns is a bigint field. I noticed that the combined >> index

Re: [BUGS] BUG #6092: specific casting required for gist indexing of bigint

2011-07-05 Thread Tom Lane
"Jeff Frost" writes: > Ran into a situation with a customer who is using the btree_gist contrib > module to allow combined index of some tsearch data and two other columns. > One of these other columns is a bigint field. I noticed that the combined > index won't be used by the planner unless you

[BUGS] BUG #6092: specific casting required for gist indexing of bigint

2011-07-05 Thread Jeff Frost
The following bug has been logged online: Bug reference: 6092 Logged by: Jeff Frost Email address: j...@pgexperts.com PostgreSQL version: 9.0.4 Operating system: CentOS 5.5 Description:specific casting required for gist indexing of bigint Details: Ran into a situati