search

knizhnik / imcs

In-Memory Columnar Store extension for PostgreSQL
Apache License 2.0
203 stars 33 forks source link

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

Closed amutu closed 10 years ago

amutu commented 10 years ago

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 commented 10 years ago

I added attribute name to this error message

amutu commented 10 years ago

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 commented 10 years ago

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 commented 10 years ago

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