Unable `IMPORT FOREIGN SCHEMA` for read-only file location

pgspider / sqlite_fdw

SQLite Foreign Data Wrapper for PostgreSQL

Other

218 stars 37 forks source link

Unable `IMPORT FOREIGN SCHEMA` for read-only file location #65

Closed mkgrgis closed 1 year ago

mkgrgis commented 1 year ago

We have read-only remote file location with read-only SQLite file. When try to execute IMPORT FOREIGN SCHEMA there is a message: ERROR: SQLite failed to execute SQL: BEGIN. There is no rights for (transaction) temporary files in directory of database file for postgres OS user, but conceptually this can't be a problem for IMPORT FOREIGN SCHEMA on read-only database file because file is read-accessible for postgres OS user.

mkgrgis commented 1 year ago

Fixed during second checking and setting read rights on directories by path to database. I am sorry. No problems with read-only database file and read-only directory near them.