I figured out my trigger trouble:
SET lang_code_and_text = r.lang_code_and_text || ARRAY[new.iso_id,
default_text]
Above was not casting ARRAY[] as text[] so it would not concatenate
with existing array - so had to set a variable to cast the type and
then concatenate it to original and also had to return NULL since this
is an after trigger.
Regards,
David
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
