Обсуждение: Using contrib/fulltext on multiple tables.
I am running into a problem with using contrib/fulltext on several tables. Here's the details... I have one sql script which drops everything and recreates the database structure, then populates it with some test data. In this script I create tables a,b and c and setup the triggers for fulltext indexing (as well as associated tables for the index data). 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. If I just have a and c setup in the script, they both work. Same for a and b. It seems to be a problem with b and c. Something else that is odd is I can then call the Insert stored procedure for c and it's index doesn't get created. However, if I exit and reenter the psql client app, THEN run the Insert stored procedure, the index is created just fine. I've tried breaking it into two scripts (one for db structure and one for test data) but it still doesn't do the indexing on c. Any Ideas? I apologize for the length, Eric
"Eric Johnson" <ej@ejinnovations.com> writes: > I am running into a problem with using contrib/fulltext on several tables. That sounds awfully weird. Could we see a complete, reproducible example? And what PG version are you using, anyway? (Might be better to continue this on pgsql-bugs than -general.) regards, tom lane
Sure thing, I'll get subscribed to -bugs and send it! -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Tom Lane Sent: Friday, August 01, 2003 11:06 PM To: Eric Johnson Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Using contrib/fulltext on multiple tables. "Eric Johnson" <ej@ejinnovations.com> writes: > I am running into a problem with using contrib/fulltext on several tables. That sounds awfully weird. Could we see a complete, reproducible example? And what PG version are you using, anyway? (Might be better to continue this on pgsql-bugs than -general.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster