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> |
Subject: | Re: Using contrib/fulltext on multiple tables. |
Date: | 2003-08-04 01:29:26 |
Message-ID: | 6361.1059960566@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
"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
From | Date | Subject | |
---|---|---|---|
PostgreSQL : | Eric Johnson | 2003-08-04 03:06:27 | PostgreSQL : Re : 여러 테이블무지개 토토 Contrib/FullText |
Previous Message | Tom Lane | 2003-08-04 01:12:38 | Re: PostgreSQL 7.3.3 with pgcrypto on FreeBSD 5.1 |