Skip to content

Insert method does not generate SQL suitable for PostgresSQL #173

@brenolo04

Description

@brenolo04

The method generates sql that returns the identifier that was generated by the database, but the sql writing that was generated from the returning writes a reserved word from the postgres database (it should write the "Id" field in double quotation marks to identify the field). For this reason, it generates an error in the insertion. Is there any way to convert this situation?

This is the SQL generated by contrib
insert into "User" ("Name", "Email", "PasswordHash", "Bio", "Image", "Slug") values ($1, $2, $3, $4, $5, $6) RETURNING Id

Metadata

Metadata

Assignees

No one assigned

    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