Skip to content

Support LOCK TABLE queries #1643

Open
Open
Support LOCK TABLE queries#1643
Labels
📚 postgresqlenhancementNew feature or request

Description

@juhaszp-uhu
juhaszp-uhu
opened on May 25, 2022

What do you want to change?

Postgresql has a query type, LOCK TABLE, which is not supported by sqlc: it seems to be silently ignored, no code is generated for it. Of course it's possible to use such a query with a raw pgx call, but it would be neat if sqlc supported it out of the box.

What database engines need to be changed?

PostgreSQL

What programming language backends need to be changed?

Go, Python, Kotlin

Activity

  1. juhaszp-uhu
    added
    enhancementNew feature or request
    triageNew issues that hasn't been reviewed
    on May 25, 2022
  2. kyleconroy
    added
    📚 postgresql
    and removed
    triageNew issues that hasn't been reviewed
    on Jun 4, 2022

  3. kyleconroy commented on Jun 4, 2022

    @kyleconroy
    kyleconroy
    on Jun 4, 2022
    Collaborator

    Today sqlc only supports generating queries for certain subset of query types (SELECT / INSERT / UPDATE / DELETE).

    I'd be happy to add support for more queries.

  4. kyleconroy commented on Jun 4, 2022

    @kyleconroy
    kyleconroy
    on Jun 4, 2022
    Collaborator

    Tracking here #1661

  5. kyleconroy
    changed the title [-]support LOCK TABLE queries[/-] [+]Support LOCK TABLE queries[/+] on Sep 26, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    📚 postgresqlenhancementNew feature or request

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions