print detail info of “ERROR: String length 34 is larger then element size 32”

[amutu]

I get this error message:
ERROR: String length 34 is larger then element size 32
CONTEXT: PL/pgSQL function xx_load(boolean,text) line 1 at RETURN

It may be some unicode relative but here I think we can print more info such as which column this error happened, add the string value even better.

I write this becasue I have a table with 10 clumns defined as char(32),the table has million rows, it is difficult to find what value cause the error.

[knizhnik]

I added attribute name to this error message

[amutu]

thank you very much!
But it looks like I find other bug aoubt this:
the ERROR cause the CS partly load data.When Error happened,there seams no code clean the loaded data.If I append data and get this error,then I will get mess the cs and hard to continue the load action or clean the partly loaded data.

[knizhnik]

Sorry, IMCS is non-transactional.
If something going wrong during adding values to columnar store, I can just remove all data associated with this table. But I do not want to do it always implicitly. You can do it explicitly using Table_delete() function.

[amutu]

I see and thank you for your quick response.
I will load the data carefully and add check constraint for the char(n) column.