PostgreSQL无法update
Open
enhancement
- Dominant language
- Java
- Stars
- 17.4k
- Forks
- 5.7k
- PR merge metrics
- No merged PRs in 30d
Description
是否可以通过下面的方式来解决无法update的问题呢?
`INSERT ... ON CONFLICT [ conflict_target ] conflict_action`
例如
`
INSERT INTO test_postgre(id,name,InputTime,age)
VALUES('1','postgre','2018-01-10 22:00:00',24)
ON conflict(id)
DO UPDATE SET name = 'postgreOk', InputTime ='2018-02-22 12:00:00'
`
Contributor guide
No contributing guide indexed for this repository
Research direction
The issue names no files, tests, or entry points. Start by locating PostgreSQL writer handling for update or conflict behavior, then determine how the proposed INSERT ... ON CONFLICT syntax fits the existing configuration; done means existing rows can be updated through the requested PostgreSQL conflict action.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100