postgres_scanner icon indicating copy to clipboard operation
postgres_scanner copied to clipboard

Help compiling duckdb and error loading postgres: `undefined symbol: _ZTIN6duckdb7CatalogE`

Open MarceloZabini opened this issue 4 months ago • 1 comments

Apologies if this is not the right place to ask for help.

When LOADing the postgres extension that I compiled myself, I am running into

Extension "/home/mzabani/duckdb/build/release/extension/postgres_scanner/postgres_scanner.duckdb_extension" could not be loaded: /home/mzabani/duckdb/build/release/extension/postgres_scanner/postgres_scanner.duckdb_extension: undefined symbol: _ZTIN6duckdb7CatalogE

I have duckdb cloned and checked out at the v1.3.2 tag, and duckdb-postgres cloned and checked out at c3024b5c8570695dc73422066fcd221ed64761de, which seemed like the best match since the duckdb git submodule is also at v1.3.2.

I then have the following extension_config.cmake file in the duckdb repo (last line might be the actual relevant one):

duckdb_extension_load(autocomplete)
duckdb_extension_load(core_functions)
duckdb_extension_load(httpfs SOURCE_DIR /home/mzabani/duck-read-cache-fs/duckdb-httpfs INCLUDE_DIR /home/mzabani/duck-read-cache-fs/duckdb-httpfs/extension/httpfs/include)
duckdb_extension_load(cache_httpfs SOURCE_DIR /home/mzabani/duck-read-cache-fs)
duckdb_extension_load(ducklake SOURCE_DIR /home/mzabani/ducklake)
duckdb_extension_load(icu)
duckdb_extension_load(json)
duckdb_extension_load(parquet)
duckdb_extension_load(postgres_scanner DONT_LINK SOURCE_DIR /home/mzabani/duckdb-postgres)

After that I ran GEN=ninja EXTENSION_CONFIGS="extension_config.cmake" make to compile. Is this something obvious I'm missing from the build instructions?

Thanks in advance.

MarceloZabini avatar Sep 17 '25 13:09 MarceloZabini

I'm having the same issue!

tobwen avatar Nov 06 '25 19:11 tobwen