cannot cast type timestamptz to timestamp
🐜 This seems to be an execution error, which means that your request syntax seems okay,
but the resulting statement cannot be executed → Probably not a pg-mem error.
*️⃣ Failed SQL statement: /* doesn't matter */ where sessions.timestamp > now();
👉 You can file an issue at https://github.com/oguimbal/pg-mem along with a way to reproduce this error (if you can), and the stacktrace:
To Reproduce
CREATE TABLE "user" ("id" SERIAL NOT NULL, "timestamp" timestamp NOT NULL, PRIMARY KEY ("id"));
INSERT INTO "user"("timestamp") VALUES (now()) RETURNING "id";
SELECT FROM "user" WHERE "timestamp" > now()
pg-mem version
2.6.13
Patch to fix (probably, a bad one)
Worked for me, but should be thoroughly tested with different type combinations.
Describe the bug
The casting of timestamps doesn't work
To Reproduce
pg-mem version
2.6.13
Patch to fix (probably, a bad one)
Worked for me, but should be thoroughly tested with different type combinations.