Using contrib/fulltext on multiple tables.

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

I am running into a problem with using contrib/fulltext on several tables.

postgres 7.3.2, script attached.

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

Attachment Content-Type Size
RecipeDb.sql text/plain 18.5 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sean Chittenden 2003-08-02 05:36:08 Re: PostgreSQL 7.3.3 with pgcrypto on FreeBSD 5.1
Previous Message Tom Lane 2003-08-02 02:50:44 Re: pg_hba.conf changes