run: postgres.sql('SELECT 1') failes in postgres (and presumably any db) without drop database permissions

malloydata / malloy

Malloy is an experimental language for describing data relationships and transformations.

http://www.malloydata.dev

MIT License

2.01k stars 76 forks source link

run: postgres.sql('SELECT 1') failes in postgres (and presumably any db) without drop database permissions #1773

Open bporterfield opened 4 months ago

bporterfield commented 4 months ago

What happens?

running any SQL like this seems to go through a path that attempts to drop database , resulting in an error if user does not have drop database permissions. Seems like that should not be required cc @lloydtabb

To Reproduce

run: {your_connection_name}.sql('SELECT 1') with a connection that does not have drop database rights

OS:

macOS

Malloy Client:

local VSCode

Malloy Client Version:

latest

Database Connection:

Postgres

bporterfield commented 4 months ago

Is this as simple as removing this line?

Doesn't seem like there's a good chance the name will exist since the name is generated from randomUUID()

bporterfield commented 4 months ago

@christopherswenson or @whscullin if either of y'all wanna 👍 I'm happy to make a PR that removes the line