Oleg Bartunov writes:
Francisco,
you need to say us standard information about pg version
Postgresql 8.2 running in FreeBSD.
error message you got.
ERROR: operator does not exist: text || tsvector
Also, it'd be worth to show simplified version of your function, which
demonstrates your problem.
I did include that.
The function looks like:
AS $$
DECLARE
v_sql TEXT;
BEGIN
v_sql := 'INSERT INTO messagecatalog_'||
to_char(NEW.timestampfield,'YYYY')||
'(field1, field2) values ('
||New.field1||','||New.field2||')
')';
EXECUTE v_sql;
RETURN NULL;
END
$$;
In the code above field1 is text and field2 is tsvector.
Basically I am trying to do partitioning. I have a master table, some
children which inherit from the master. Inserts will be redirected with a
trigger from the master to the children. The function I am having the
problem with is what the trigger calls to do the redirection.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
