Postgres Pro
Downloads
Home   >   mailing lists

Thread: Using contrib/fulltext on multiple tables.

Using contrib/fulltext on multiple tables.

From
"Eric Johnson"
Date:
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

Re: Using contrib/fulltext on multiple tables.

From
Tom Lane
Date:
"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

Re: Using contrib/fulltext on multiple tables.

From
"Eric Johnson"
Date:
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