The schema below crashes pretty reliably for me. There are three
objects: an immutable function, a table called a and a gin index on
table a using the immutable function. To reproduce the crash, do
enough inserts into table a to kick off the auto-vacuum process; the
insert statement below with the generate_series should do this. I
tested this on Windows Vista using PG 9.0 and also on Linux (RHES4)
using 8.4.4 (both packaged by EnterpriseDB) and it crashed both
servers.
Thanks
Andrew
create or replace function get_fts_config_name() returns regconfig as $$
select setting::regconfig from pg_settings
where name = 'default_text_search_config';
$$ language sql immutable;
CREATE TABLE a
(
id serial primary key,
my_text varchar(128) not null
);
create index ix_a_my_text on a using
gin(to_tsvector(get_fts_config_name(), my_text));
insert into a (my_text) select 'Test' from generate_series(1,10000);
On Wed, Sep 22, 2010 at 11:58 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Andrew Geery <andrew.ge...@gmail.com> writes:
>> I think I've tracked down the problem, although I haven't been able to
>> get a stack trace yet. I'm afraid that it's my own stupidity, but I
>> still don't understand why this crashes the entire engine.
>
> Me either. Can you narrow it down to a self-contained test case so
> others can reproduce the problem?
>
> regards, tom lane
>
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
