Question

postgres writer inserts 0 instead of actual value


I got a workspace that I run and as an output it creates one row with statistics.

If I run the workspace the output is correct both with inspector and the row written to postgres.

If I use another workspace with a workspace runner to run the workspace for multiple areas, one of my column values is 0 in every row.

Any thoughts?


2 replies

Userlevel 2
Badge +12

0 is probably the default value for the attribute in the table.

So, could it be that the attribute does not get a value (or not a valid value: char instead of number) if you run it for multiple areas?

Hope this helps finding the issue.

0 is probably the default value for the attribute in the table.

So, could it be that the attribute does not get a value (or not a valid value: char instead of number) if you run it for multiple areas?

Hope this helps finding the issue.

my last row is running the workspace manually the rows before that are when it's being run with a workspace runner. the tables are being created by me, and i haven't set any default values,

Reply