Re: Using contrib/fulltext on multiple tables.

I just noticed something about how this is behaving. When I run the script
on my machines, it's putting the index data tb_c_ingredient into
tb_c_step_fti. If I exit psql, go back in and manually insert, it goes to
the correct table tb_c_ingredient_fti.

I wrote a much simpler script (see attachment: just 3 tables being indexed,
3 triggers, and 3 index-data tables) and am having the same problem - only
all the data is going into the first table's index until I logout and go
back in.

It may be worth noting the following error if I run the script multiple
times in the same psql session:

psql:bug.sql:66: ERROR: pg_class_aclcheck: relation 125816 not found
psql:bug.sql:67: ERROR: pg_class_aclcheck: relation 125816 not found
psql:bug.sql:68: ERROR: pg_class_aclcheck: relation 125816 not found

That's happening on the INSERT INTO table1 ... table2 ... and table3
statements.

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
>