Skip to content

UTA database recreates schema on startup #430

@zealws

Description

@zealws

Describe the bug

The UtaDatabase class recreates the schema in the create function.

This results in the schema being recreated every time the class is instantiated, regardless of whether the schema exists or not.

This is most clearly an issue if the UTA user doesn't have permission to recreate tables, because it results in an error, even if the schema is already setup correctly.

Steps to reproduce

Instantiate PostgresDatabase (or use any of the functions that rely on it)

Expected behavior

If the schema already exists: it uses the existing schema without modifying it.

Current behavior

It recreates the schema, regardless of if it exists or not.

Possible reason(s)

No response

Suggested fix

No response

Branch, commit, and/or version

main

Screenshots

No response

Environment details

Not relevant

Additional details

No response

Contribution

None

Metadata

Metadata

Assignees

Labels

bugSomething isn't workingpriority:mediumMedium priority

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions