(slick / slickCodegen) column t1.tgconstrname does not exi

[salkc...@gmail.com]

hello, geeks .... am having this issue with slick codegen. slick codegen failed to run after postgresql upgrade to 10.3.... it has been giving this column errror that doesnt seem intuitive .

this is the stacktrace... the column specified as nonexistent is not part of my db migration.

[error] org.postgresql.util.PSQLException: ERROR: column t1.tgconstrname does not exist

[error]   Position: 113

[error] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)

[error] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)

[error] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

[error] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:562)

[error] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)

[error] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:286)

[error] at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedExportedKeys(AbstractJdbc2DatabaseMetaData.java:3580)

[error] at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedKeys(AbstractJdbc2DatabaseMetaData.java:3775)

[error] at slick.jdbc.meta.MForeignKey$.$anonfun$getImportedKeys$1(MForeignKey.scala:17)

[error] at slick.jdbc.ResultSetInvoker$$anon$4.createResultSet(ResultSetInvoker.scala:36)

[error] at slick.jdbc.ResultSetInvoker.iteratorTo(ResultSetInvoker.scala:19)

[error] at slick.jdbc.Invoker.foreach(Invoker.scala:47)

[error] at slick.jdbc.Invoker.foreach$(Invoker.scala:46)

[error] at slick.jdbc.ResultSetInvoker.foreach(ResultSetInvoker.scala:14)

[error] at slick.jdbc.StreamingInvokerAction.run(StreamingInvokerAction.scala:22)

[error] at slick.jdbc.StreamingInvokerAction.run$(StreamingInvokerAction.scala:20)

[error] at slick.jdbc.ResultSetAction$$anon$1.run(ResultSetInvoker.scala:42)

[error] at slick.jdbc.ResultSetAction$$anon$1.run(ResultSetInvoker.scala:42)

[error] at slick.basic.BasicBackend$DatabaseDef$$anon$2.liftedTree1$1(BasicBackend.scala:242)

[error] at slick.basic.BasicBackend$DatabaseDef$$anon$2.run(BasicBackend.scala:242)

[error] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

[error] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

[error] at java.lang.Thread.run(Thread.java:748)

[error] (slick / slickCodegen) org.postgresql.util.PSQLException: ERROR: column t1.tgconstrname does not exist

[error]   Position: 113

[error] Total time: 7 s, completed Aug 24, 2018 2:54:03 AM

[INFO] [08/24/2018 02:54:03.866] [Thread-4] [CoordinatedShutdown(akka://sbt-web)] Starting coordinated shutdown from JVM shutdown hook

what i have tried: 

1. i have tried to run it on another schema instead of the postgresql public schema
   
2. the postgresql version doesnt seem to be the problem , because i have other project running slick with the same postgresql version, but arent using codegen.

any help is appreciated . thanks.

[chakravarthi ponmudi]

did you get any solution for this problem?

[salk chtin]

No....I guess slick codegen doesn't work with postgresql 10 upward.....I have since then deprecated codegen and use the normal slick ....

--

---
You received this message because you are subscribed to the Google Groups "Slick / ScalaQuery" group.
To unsubscribe from this group and stop receiving emails from it, send an email to scalaquery+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/scalaquery/784181eb-3e5c-42b3-a401-5c025065e62c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.