Unable to specify PostgreSQL tablespace when building schema

[remi9898]

Running HammerDB 3.3 on CentOS 7.7 kernel 3.10.0-1062.

The build schema options for PostgreSQL don't appear to allow specifying a tablespace. For Oracle, the build schema options has line to enter tablespace name. Not for PostgreSQL.

If I manually create the tpcc or tpch databases in my tablespace called hammerdb on /pgdata1/data, then HammerDB's build schema fails with error like "database tpch already exists".

For now the workaround is to move template1 to my desired tablespace so that when HammerDB issues the create database statement the new database will inherit template1's tablespace setting. Not best since I have to remember to change it back, and to change it each time I want to use a different tablespace.

Thanks.

[sm-shaw]

This is a valid feature request and straightforward to add. Would you like to go ahead and try and add these changes yourself and submit a pull request to have them merged? This will be the quickest way for inclusion. If not it will be added to the list of feature requested and added when time permits.

[remi9898]

Thanks. I'm not a good choice for modifying the code.

…

On Fri, Nov 22, 2019 at 10:48 AM Steve Shaw ***@***.***> wrote: This is a valid feature request and straightforward to add. Would you like to go ahead and try and add these changes yourself and submit a pull request to have them merged? This will be the quickest way for inclusion. If not it will be added to the list of feature requested and added when time permits. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#81?email_source=notifications&email_token=AK4TAT2S3HCCTOM4UD6KKUTQU75LVA5CNFSM4JPXTISKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEE6BAIA#issuecomment-557584416>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AK4TATZTXXBPYK4AADZ7RMLQU75LVANCNFSM4JPXTISA> .

[sm-shaw]

Changes added in Pull Request : PostgreSQL prepared statements for functions and tablespace option for schema builds #95

[sm-shaw]

Closed per pull request PostgreSQL prepared statements for functions and tablespace option for schema builds #95