Hi!
I am in the process of migrating a PostgreSQL 8.2.4 database to 8.3. So
far=
, everything has worked fine, even tsearch2-searching an indexed table.
There's something severely wrong with the trigger-function I use to keep
th=
e tsvector-column updated.
Here's my table definition:
CREATE TABLE public.ct_com_board_message
(
board_id integer DEFAULT 0,
thread_id integer DEFAULT 0,
father_id integer DEFAULT 0,
message_id integer NOT NULL DEFAULT 0,
user_id integer DEFAULT 0,
title text,
signature text,
follow_up text,
count_reply integer DEFAULT 0,
last_reply timestamptz,
created timestamptz DEFAULT now(),
article_id integer DEFAULT 0,
logged_ip text,
state_id smallint DEFAULT 0,
text text,
deleted_date timestamptz,
deleted_login text,
poll_id integer DEFAULT 0,
last_updated timestamptz DEFAULT now(),
idxfti tsvector,
CONSTRAINT "pk_ct_com_board_message" PRIMARY KEY (message_id)
);
And there's this trigger definition:
CREATE TRIGGER "tsvectorupdate"
BEFORE=20
INSERT OR UPDATE=20
ON "public"."ct_com_board_message"
FOR EACH ROW=20
EXECUTE PROCEDURE
pg_catalog.tsvector_update_trigger(idxfti,pg_catalog.germ=
an,title,text,user_login);
Now when I do anything that fires the trigger like
UPDATE ct_com_board_message set count_reply =3D 1 where message_id =3D
1234=
5;
I get an error
ERROR: column "idxfti" is not of tsvector type
I didn't touch the tsvector_update_trigger-function at all, it still reads
CREATE or REPLACE FUNCTION "pg_catalog"."tsvector_update_trigger"()
RETURNS "pg_catalog"."trigger" AS=20
$BODY$
tsvector_update_trigger_byid
$BODY$
LANGUAGE 'internal' VOLATILE;
So what's happening here?
Kind regards
Markus
Computec Media AG
Sitz der Gesellschaft und Registergericht: F=FCrth (HRB 8818)
Vorstandsmitglieder: Johannes S. G=F6zalan (Vorsitzender) und Rainer
Rosenb=
usch
Vorsitzender des Aufsichtsrates: J=FCrg Marquard=20
Umsatzsteuer-Identifikationsnummer: DE 812 575 276
--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
|
