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 we make user mapping optional e.g. for SQLite? #100

Open
mlt opened this issue Oct 12, 2019 · 0 comments
Open

Can we make user mapping optional e.g. for SQLite? #100

mlt opened this issue Oct 12, 2019 · 0 comments

Comments

@mlt
Copy link

mlt commented Oct 12, 2019

Context

One usually connects to SQLite without any authentication. However odbc_fdw expects for user mapping to exist.

Steps to Reproduce

  1. Have SQLite data source
  2. CREATE SERVER odbc_sqlite FOREIGN DATA WRAPPER odbc_fdw OPTIONS (driver 'SQLite3 ODBC Driver', odbc_database 'C:\path\to\sqlite3.db', odbc_bigint 'true' ); (I am on Windows)
  3. Forget to include CREATE USER MAPPING FOR current_user SERVER odbc_sqlite;
  4. Try to import tables IMPORT FOREIGN SCHEMA main FROM SERVER odbc_sqlite INTO public;

Current Result

Get user mapping not found for "myuser"

Expected result

Have table in public schema.

System trying to connect to and version

Tried with PostgreSQL 11 on MS Windows 64 bit with SQLite ODBC driver from http://www.ch-werner.de/sqliteodbc/ .

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