Using contrib/fulltext on multiple tables.

From: "Eric Johnson" <ej(at)ejinnovations(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Using contrib/fulltext on multiple tables.
Date: 2003-08-02 03:22:37
Message-ID: DCEIINBKBKJLLIFKJJGNAEOODBAA.ej@ejinnovations.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-08-02 03:25:58 Re: Monthly table partitioning for fast purges?
Previous Message Tom Lane 2003-08-02 02:32:40 Re: CREATE TABLE with a column of type {table name}