Indefinite hang with Python module

[davetapley]

What happens?

I can successfully CALL postgres_attach from the duckdb CLI, but it hangs indefinitely via Python module.

To Reproduce

Get a local Postgres server running.

Verify this works in duckdb CLI:

INSTALL postgres;
LOAD postgres;
CALL postgres_attach('host=localhost dbname=postgres user=postgres password=password');

Run python and paste:

db = duckdb.connect()
db.execute('''
INSTALL postgres;
LOAD postgres;
CALL postgres_attach('host=localhost dbname=postgres user=postgres password=password');
''')

Observe it hangs indefinitely.

OS:

Ubuntu 18.04.01

PostgreSQL Version:

Ubuntu 10.22-0ubuntu0.18.04.1

DuckDB Version:

0.6.0

DuckDB Client:

Python

Full Name:

Dave Tapley

Affiliation:

JE Fuller

Have you tried this on the latest master branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree

[davetapley]

Couldn't repro this now.