ERROR: value too long for type character varying(6)

Question

ERROR: value too long for type character varying(6)

NicholasLYang opened this issue 5 years ago · 4 comments

We're using varchar(n) on certain fields, causing errors on scrape when the value is too big. We should get better reporting for this btw, it's unclear which course this is.

According to the Postgres wiki varchar(n) isn't advisable in the first place, so we should probably just change these to varchar unless there's a very good reason to the contrary.

Answer 1 · 2020-06-03T06:52:55.000Z

Even if we're using varchar(n) as validation, we should probably catch this in code and spit out the row. That way we can tell if it's bad data or a genuine exception.

Answer 2 · 2020-06-03T13:46:14.000Z

Are you on latest? I added error printing for this a few days ago.

Answer 3 · 2020-06-03T13:46:53.000Z

Oh lol nvm I didn't push it to master so its not on your fork.

Answer 4 · 2020-06-03T16:50:08.000Z

This has been fixed.