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
Trying to do an insert based on a CTE (with) and I get the following:
🔨 Not supported 🔨 : "WITH" nested statement with query type 'insert'
👉 pg-mem is work-in-progress, and it would seem that you've hit one of its limits.
*️⃣ Reconsituted failed SQL statement: WITH a AS (SELECT * FROM foo ) INSERT INTO bar SELECT * FROM a
👉 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
createtablefoo (x integer);
createtablebar (x integer);
insert into foo values (1), (2);
insert into bar select*from foo;
with a as (
select*from foo
)
insert into bar select*from a;
First insert works but the second doesn't despite them being functionally identical (and both working in postgres 14.1
pg-mem version
2.8.1
The text was updated successfully, but these errors were encountered:
Describe the bug
Trying to do an insert based on a CTE (with) and I get the following:
To Reproduce
First insert works but the second doesn't despite them being functionally identical (and both working in postgres 14.1
pg-mem version
2.8.1
The text was updated successfully, but these errors were encountered: