Re: Using contrib/fulltext on multiple tables. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Using contrib/fulltext on multiple tables.
Date
Msg-id 6361.1059960566@sss.pgh.pa.us
Whole thread Raw
In response to Using contrib/fulltext on multiple tables.  ("Eric Johnson" <ej@ejinnovations.com>)
List pgsql-bugs
"Eric Johnson" <ej@ejinnovations.com> writes:
> Later in the script when inserting into these tables via stored procedures,
> the full text indexes get created for a and b but not c.  It's just empty.

I can't reproduce this in either 7.3 or CVS tip.  The index tables seem
to have reasonable numbers of entries in them after running your script:

recipe=# select count(*) from tb_c_step_fti;
 count
-------
    41
(1 row)

recipe=# select count(*) from tb_c_recipe_fti;
 count
-------
   207
(1 row)

recipe=# select count(*) from tb_c_ingredient_fti;
 count
-------
   103
(1 row)

If that wasn't what you meant, you'll need to be more specific.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL 7.3.3 with pgcrypto on FreeBSD 5.1
Next
From: "Eric Johnson"
Date:
Subject: Re: Using contrib/fulltext on multiple tables.