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

failed to open sqlite db error #41

Open
icefairy opened this issue Mar 28, 2024 · 2 comments
Open

failed to open sqlite db error #41

icefairy opened this issue Mar 28, 2024 · 2 comments

Comments

@icefairy
Copy link

pg15
duckdb 0.10.1

create server ds foreign data wrapper duckdb_fdw options (database '/home/postgres/duckdb');

select duckdb_execute('ds','create table t1(a integer ,b integer ,c varchar(10));');
ERROR: failed to open SQLite DB. rc=1 path=/home/postgres/duckdb

select duckdb_execute('ds','create or replace view myv select now();');
ERROR: failed to open SQLite DB. rc=1 path=/home/postgres/duckdb

the fdw just worked with precreated database with duckdb cli,I want to know if it can work without duckdb cli,just use duckdb with fdw and duckdb_execute to create table and using it? thanks

@icefairy
Copy link
Author

the directory of /home/postgres/duckdb is owner by postgres,the permssions are setting ok (because it works with created database using duckdb cli)

@alitrack
Copy link
Owner

alitrack commented Apr 5, 2024

/home/postgres/duckdb is a directory or duckdb database path?

if db, make sure postgres use has the owner of it.

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

2 participants