Currently, MoveToPublicSchema job is transferring data from buffer to public schema with an INSERT from SELECT * .
This is very risky when the order of the columns are not the same between the 2 schemas.
To fix that, we should explicitly add the name of columns to the INSERT and the SELECT statements.
Add to configuration file gettablecolumnsquery (e.g. Postgresql value : SELECT column_name FROM information_schema.columns WHERE
table_schema = 'public' and table_name='occurrence' )
Modify related tasks to use the returned set of column names
Currently, MoveToPublicSchema job is transferring data from buffer to public schema with an INSERT from SELECT * .
This is very risky when the order of the columns are not the same between the 2 schemas. To fix that, we should explicitly add the name of columns to the INSERT and the SELECT statements.