Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can I directly call Greenplum functions using Postgre extensions #303

Open
PlumJade opened this issue Feb 25, 2025 · 0 comments
Open

Can I directly call Greenplum functions using Postgre extensions #303

PlumJade opened this issue Feb 25, 2025 · 0 comments

Comments

@PlumJade
Copy link

When I write the following code in DuckDB:

CREATE SECRET ps (
TYPE postgres,
HOST '${ip}',
PORT ${port},
DATABASE ${dbname},
USER '${user}',
PASSWORD '${password}'
);

ATTACH 'dbname=${dbname}' AS gp (TYPE postgres, SECRET ps);

CALL postgres_execute('gp', 'SELECT * FROM gp.dw.getcombinesn(''HF52RT0006'')');
I encounter the following error:

ERROR: cross-database references are not implemented: gp.dw.getcombinesn
Is it possible to directly call Greenplum functions using the Postgres extension in DuckDB?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant