search

cwida / duckpgq-extension

DuckDB extension that adds support for SQL/PGQ
https://duckpgq.notion.site/b8ac652667964f958bfada1c3e53f1bb?v=3b47a8d44bdf4e0c8b503bf23f1b76f2
MIT License
72 stars 7 forks source link

Merge with DuckD v0.10.2 #118

Closed Dtenwolde closed 5 months ago

Dtenwolde commented 6 months ago

See #108 for instructions

Dtenwolde commented 6 months ago

Merged with https://github.com/cwida/duckpgq-extension/commit/2d35ad8852a890db074cd868ef882db6a49297a8 and https://github.com/cwida/duckdb-pgq/commit/05fb3d5cb4c7b04b1d599cae8fc8312f265d2d86

Dtenwolde commented 6 months ago

The extension is successfully deployed, however there is an issue with the new footer introduced by https://github.com/duckdb/duckdb/pull/11515 making the extensions not loadable from stock DuckDB. DuckDB devs are aware of the issue, but a workaround for now is to install the extension: 

set custom_extension_repository = 'http://duckpgq.s3.eu-north-1.amazonaws.com';
force install 'duckpgq';

Navigate to the folder where DuckDB extensions are stored (by default ~/.duckdb/extensions/v0.10.2/<os_architecture>/) Then truncate the last 256 bytes of the duckpgq.duckdb_extension file: truncate -s -256 duckpgq.duckdb_extension The extension is now loadable 

load 'duckpgq';

Leaving this issue open for now until this loading issue has been fixed

Dtenwolde commented 5 months ago

Fixed as of https://github.com/cwida/duckpgq-extension/commit/d88b7f93093bb310e34e18971a59e58df45e2530

Extensions can now be loaded in DuckDB v0.10.2