django-daiquiri / daiquiri

A framework for the publication of scientific databases
https://escience.aip.de/daiquiri
Apache License 2.0
26 stars 8 forks source link

BUG: the tablespace setting has no effect on the uploaded tables #243

Open kimakan opened 3 months ago

kimakan commented 3 months ago

The settings variable USER_TABLESPACE sets the tablespace for the tables created by the daiquiri user. However, it's not taken into account for the uploaded tables. For the query job, the tablespace is selected correctly via https://github.com/django-daiquiri/daiquiri/blob/39d911087655b842303f94516cbf34ae0f173ee5/daiquiri/core/adapter/database/postgres.py#L121-L126

Tablespace is missing in the table creation statement for the upload

https://github.com/django-daiquiri/daiquiri/blob/39d911087655b842303f94516cbf34ae0f173ee5/daiquiri/core/adapter/database/base.py#L211-L218