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

gdb:pgsql pgsql driver INERT IGNORE support #3853

Open
YanCastle opened this issue Oct 12, 2024 · 6 comments
Open

gdb:pgsql pgsql driver INERT IGNORE support #3853

YanCastle opened this issue Oct 12, 2024 · 6 comments

Comments

@YanCastle
Copy link

Is your feature request related to a problem?

Option Yes

Describe the solution you'd like

while use pgsql with InsertIgnore method,it`s error with not support ,

Describe alternatives you've considered

i have bing for this features,
pgsql support
ON CONFLICT DO NOTHING
it`s seem to mysql INSERT IGNORE

Additional

No response

@YanCastle
Copy link
Author

this is a demo
https://cloud.tencent.com/developer/article/2359029

ON CONFLICT DO NOTHING;

@wwwfeng
Copy link
Contributor

wwwfeng commented Oct 14, 2024

我理解INERT IGNORE 这个方法是任意冲突忽略,但是 ON CONFLICT DO NOTHING 需要明确指定冲突的列或约束

@Issues-translate-bot
Copy link

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


I understand that INERT IGNORE is a method that ignores any conflicts, but ON CONFLICT DO NOTHING requires explicitly specifying conflicting columns or constraints.

@YanCastle
Copy link
Author

我理解INERT IGNORE 这个方法是任意冲突忽略,但是 ON CONFLICT DO NOTHING 需要明确指定冲突的列或约束

我试了不要指定约束就可以完成的,

@Issues-translate-bot
Copy link

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


I understand that INERT IGNORE method ignores any conflicts, but ON CONFLICT DO NOTHING requires explicitly specifying conflicting columns or constraints.

I tried it and it can be done without specifying constraints.

Copy link

Hello @YanCastle. We like your proposal/feedback and would appreciate a contribution via a Pull Request by you or another community member. We thank you in advance for your contribution and are looking forward to reviewing it!
你好 @YanCastle。我们喜欢您的提案/反馈,并希望您或其他社区成员通过拉取请求做出贡献。我们提前感谢您的贡献,并期待对其进行审查。

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

No branches or pull requests

4 participants