"Dennis Noordsij" writes:
> create table foo ( ts tsvector not null );
> create index foo_idx on foo using gin(ts);
> insert into foo values (to_tsvector('Lore ipsum'));
> select * from foo where 'ipsu:*'::tsquery @@ ts;
> [crash]
Hmm. It rather looks to me like this
cmp = DatumGetInt3
The following bug has been logged online:
Bug reference: 4814
Logged by: Dennis Noordsij
Email address: dennis.noord...@helsinki.fi
PostgreSQL version: 8.4 SNAP 17MAY
Operating system: Linux
Description:Segmentation fault when using indexed prefix FT search
Details:
"Helena Biander" writes:
> creating template1 database in E:/PostgresData/base/1 ... WARNING: could
> not query value for 'std' to identify Windows timezone: 2
> WARNING: could not find a match for Windows timezone "Võsteuropa,
> normaltid"
> FATAL: conditional UNION/INTERSECT/EXCEPT statement
The following bug has been logged online:
Bug reference: 4813
Logged by: Helena Biander
Email address: hebiguard-s...@yahoo.se
PostgreSQL version: 8.3.7.1
Operating system: Windows XP
Description:Database can not be initialized
Details:
When I try to initialize I ge
Tom Lane wrote:
"Paul Mathews" writes:
Despite the existence of the index, postgresql is determined to full table
scan when given.
SELECT
postcode
WHERE
boundary @> point 'x,y';
polygon @> point isn't an indexable operator. The indexable operators
for a gi
On Sun, May 17, 2009 at 1:01 AM, Tom Lane wrote:
> Dave Page writes:
>> Hmm, that was easier than I expected:
>
>> perl510.dll!PerlIOUnix_refcnt_inc(int fd=0) Line 2339 C
>> perl510.dll!PerlIOUnix_setfd(interpreter * my_perl=0x,
>> _PerlIO * * f=0x, int fd=0, int imo
