malloy icon indicating copy to clipboard operation
malloy copied to clipboard

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

Open bporterfield opened this issue 7 months ago • 2 comments

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

Screenshot 2024-07-12 at 9 26 20 AM

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 avatar Jul 12 '24 16:07 bporterfield