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.