| 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 | |
|---|---|---|---|
| Next Message | Eric Johnson | 2003-08-04 03:06:27 | Re: Using contrib/fulltext on multiple tables. |
| Previous Message | Tom Lane | 2003-08-04 01:12:38 | Re: PostgreSQL 7.3.3 with pgcrypto on FreeBSD 5.1 |