BUG #2594: Gin Indexes cause server to crash on Windows - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      2594
Logged by:          Gin Indexes cause server to crash on Windows
Email address:      cfis@savagexi.com
PostgreSQL version: 8.2 CVS-Aug 28
Operating system:   Windows XP Pro
Description:        Gin Indexes cause server to crash on Windows
Details:

Download a build 8.2 CVS Head (August 28th) on Windows XP Pro.

Create a database, load tsearch2.  Then create a table:

CREATE TABLE test (
  vector tsvector NOT NULL
);

Try building a GIN index:

CREATE INDEX idx_test_vector ON test USING gin (vector);

You'll get this error message:

server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.

Note that the same code works on Linux.

Also, on Windows you can use a GIST index instead of a GIN index and it will
work fine.