sqlc icon indicating copy to clipboard operation
sqlc copied to clipboard

Temp table created using schema.sql is not insertable.

Open adi-kmt opened this issue 10 months ago • 3 comments

Version

1.26.0

What happened?

Even though the table seems to be created, its not able to insert into that table saying that the schema 'table' is not found.

Relevant log output

schema not found

Database schema

No response

SQL queries

CREATE TEMP TABLE temp_table (LIKE prev_table include ALL) ON COMMIT DROP;
INSERT INTO temp_table (...) VALUES (...)

Configuration

version: "2"
sql:
  - engine: "postgresql"
    queries: "db/query/"
    schema: "db/migrations/"
    gen:
      go:
        package: "db"
        sql_package: "pgx/v5"
        out: "db/sqlc"
        emit_interface: true
        emit_json_tags: true
        emit_pointers_for_null_types: true
        emit_result_struct_pointers: true
        overrides:

Playground URL

No response

What operating system are you using?

Linux

What database engines are you using?

PostgreSQL

What type of code are you generating?

Go

adi-kmt avatar Apr 18 '24 16:04 adi-kmt