You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When using a schema, the following insert command fails but the query runs fine in postgres. If I remove the schema from the coalesce and returning, the query succeeds.
column reference "user.name" is ambiguous
To Reproduce
CREATESCHEMAIF NOT EXISTS "s";
CREATETABLE "s"."user" ("id"SERIALNOT NULL, "name"textNOT NULL, CONSTRAINT"PK_cace4a159ff9f2512dd42373760"PRIMARY KEY ("id"));
INSERT INTO"s"."user" ("id", "name") VALUES (1, 'you') on conflict ("id") do updateset"name"= coalesce("excluded"."name", "s"."user"."name") returning "s"."user"."id";
pg-mem version
2.8.1
The text was updated successfully, but these errors were encountered:
Describe the bug
When using a schema, the following insert command fails but the query runs fine in postgres. If I remove the schema from the coalesce and returning, the query succeeds.
To Reproduce
pg-mem version
2.8.1
The text was updated successfully, but these errors were encountered: