Francisco Reyes writes:
> 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.
Any suggestions?
Anyone else has dealt with tsvectors in a partition environment?
If sow how did you get the split function/rule to insert into the child
table?