8000 `UPDATE...RETURNING` not yet supported · Issue #1421 · dolthub/doltgresql · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
UPDATE...RETURNING not yet supported #1421
Closed
@tbantle22

Description

@tbantle22

This query is used by prisma to update a value:

DEBU[2502] Received message: {"Type":"Parse","Name":"s5","Query":"UPDATE \"public\".\"departments\" SET \"manager_id\" = $1 WHERE (\"public\".\"departments\".\"dept_no\" = $2 AND 1=1) RETURNING \"public\".\"departments\".\"dept_no\", \"public\".\"departments\".\"dept_name\", \"public\".\"departments\".\"manager_id\"","ParameterOIDs":null}

And returns error

RETURNING is not yet supported

But the non-prepared version also isn't implemented and returns the same error

postgres=> update departments set manager_id=1 where (departments.dept_no=2 and 1=1) returning dept_no, dept_name, manager_id;
ERROR:  RETURNING is not yet supported

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions

    0