Neon.tech - CREATE EXTENSION IF NOT EXISTS \"uuid-ossp\ fails

Anvil Q&A
1

Hi,

I’m trying to run the below code in a Server Module

if engine.dialect.name == ‘postgresql’:
with engine.begin() as conn:
conn.execute(“CREATE EXTENSION IF NOT EXISTS "uuid-ossp"”)

I am using psotgres16 on neon.tech as my database

I’m getting the following error

ObjectNotExecutableError: Not an executable object: ‘CREATE EXTENSION IF NOT EXISTS “uuid-ossp”’

This works fine in VSCode

I am using python 3.10 beta and have psycopg2 and sqlalchemy installed on the server

Thanks in advance

1 Like