Re: Using contrib/fulltext on multiple tables.

That's exactly what I meant.  I'm getting 0 rows in tb_c_ingredient_fti.
Thank you for looking into this, I'll keep poking around as to what could be
the problem on my end (not really sure, it's a vanilla install).


Thanks again,
Eric


----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Eric Johnson" <ej@ejinnovations.com>
Cc: "Pgsql-Bugs" <pgsql-bugs@postgresql.org>
Sent: Sunday, August 03, 2003 8:29 PM
Subject: Re: [BUGS] Using contrib/fulltext on multiple tables.


> "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
>