LSIR/gsn

Database Modification

mvishnuprathap opened this issue · 1 comments

mvishnuprathap commented

Is it possible to modify database and then deploy sensors ? I got several errors occured when I tried to modify database and run the sensors again, even when I had default value of the sensors initialized to NULL.
problem

ebiiii commented

Normally you shouldn't modify the database (or maybe if you want to add an index) tables that are managed by GSN. GSN supposes that the columns correspond to the field of the virtual sensor and populate them accordingly. If you add columns and provide them a default value (ALTER TABLE vsensorname ALTER latitude SET DEFAULT '46.602'), it should work however...