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

[postgresql] Import into temp table #1416

Open
AlexeyShirshov opened this issue Feb 21, 2024 · 4 comments
Open

[postgresql] Import into temp table #1416

AlexeyShirshov opened this issue Feb 21, 2024 · 4 comments

Comments

@AlexeyShirshov
Copy link

In postgre temp table exists in special schema (pg_temp_) which is optional. You can omit it when access table, but in TableInfo.LoadData method schema is required (it is optional only for SqlServer).
You should make it optional for postgresql too.

@MIKron1991
Copy link

I had the same issue. I think we should set BulkConfig.CustomDestinationTableName to some "my_temp_table" without scheme and it would be fine, but for that we need replace :

Schema = customSchema ?? entityType.GetSchema() ?? defaultSchema;

on
Schema = customTableName != null ? customSchema : entityType.GetSchema() ?? defaultSchema;

@borisdj I can contribute, if you don't mind.

@borisdj
Copy link
Owner

borisdj commented Mar 30, 2024

@MIKron1991 sure, make a PR.

@MIKron1991
Copy link

@MIKron1991 sure, make a PR.

Done.
#1449
#1450

@borisdj
Copy link
Owner

borisdj commented Mar 30, 2024

Merged, thx for contrib.

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

3 participants