I am using Triplex package for multi-tenants. when i create a tenant. its execute all migrations. after table creation when i execute seed migrations. it gives me error "{:error, "ERROR 42P01 (undefined_table) relation \"t2.tenants\" does not exist\n\n query: (SELECT MAX(id) from \"t2.tenants\")…

I’ll respond here too, on top of slack. Also I’m assuming postgres. @kip is correct, "t2.tenants" is not the same as t2.tenants. However if you really want to quote it, you have to quote the schema and the table separately, "t2"."tenants". You can test it easily in psql. create table asd (); sele…

I think the issue is that you are quoting t2.tenants in the SELECT statement. I think it should be: execute("SELECT MAX(id) from t2.tenants")

no, it’s correct. already tried.

Why do you wrap SELECT query in parens? Also I believe that @kip is right, and "t2.tenants" mean select table default."t2.tenants" where you wanted to select from t2.tenants which would be "t2"."tenants".

Thank you jola. you are right. have seen your answer on slack as well.

Elixir Programming Language Forum

How to execute SQL SELECT query in migrations

Questions & Help Questions

elixirdev July 10, 2019, 3:26pm 7

thank you.