pg_duckdb
pg_duckdb copied to clipboard
Allow waiting on MotherDuck sync
Description
It would be good to allow users to call a function like duckdb.wait_for_motherduck_sync(). That way they could ensure that DDL changes made outside of pg_duckdb (e.g. from the duckdb CLI) would be visible to pg_duckdb.
It would also allow duckdb.enable_motherduck() to wait for the first sync to complete (which might take especially long). That way people would be sure that they would always be able to see their MD tables after duckdb.enable_motherduck().
Related to #709 Related to & blocked on #719