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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eric Johnson" <ej(at)ejinnovations(dot)com>
Cc: "Pgsql-Bugs" <pgsql-bugs(at)postgresql(dot)org>
Sent: Sunday, August 03, 2003 8:29 PM
Subject: Re: [BUGS] Using contrib/fulltext on multiple tables.

> "Eric Johnson" <ej(at)ejinnovations(dot)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
>