Skip to content

sqlc.embed does not work with VIEWs when a schema is provided #3031

Open
@DawnKosmos

Description

@DawnKosmos

Version

1.24.0

What happened?

Hello, so I have this View
CREATE OR REPLACE VIEW inventory.articles
Want to use sqlc.embed in my code
SELECT sqlc.embed(inventory.articles)FROM inventory.create_article ...
And get this error:
queries/03_article.sql:1:1: unable to resolve table with "sqlc.embed(inventoryarticles)": relation "inventoryarticles" does not exist

Neither of these 2 worked
sqlc.embed("inventory"."articles") .... SELECT sqlc.embed("inventory.articles")

Relevant log output

No response

Database schema

No response

SQL queries

No response

Configuration

No response

Playground URL

No response

What operating system are you using?

macOS

What database engines are you using?

PostgreSQL

What type of code are you generating?

Go

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingtriageNew issues that hasn't been reviewed

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions