*** Wartungsfenster jeden ersten Mittwoch vormittag im Monat ***

Skip to content

smallint range insufficient for column catchment_inh in stormw.sampling_sites_import

The smallint (int2) data type only allows values up to approximately 32,000. Since some catchments have significantly more inhabitants, I propose updating this to int4 or int8.

I encountered this issue when attempting to import data into the konda database, specifically within the stormw.sampling_sites_import view. Similar issues may exist in other schemas or tables that also have a catchment_inh column.