org.postgresql.util.PSQLException

ERROR: subquery in FROM must have an alias Hint: For example, FROM (SELECT ...) [AS] foo. Position: 57

Samebug tips1

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web3407

  • ERROR: subquery in FROM must have an alias Hint: For example, FROM (SELECT ...) [AS] foo. Position: 57
  • via oschina.net by Unknown author, 1 year ago
    ERROR: subquery in FROM must have an alias 建议:For example, FROM (SELECT ...) [AS] foo. 位置:15
  • ERROR: more than one row returned by a subquery used as an expression Error Code: 0 Call: select groupalias from explicitgroup where id = (select explicitgroup_id from explicitgroup_authenticateduser where containedauthenticatedusers_id = (select
  • Stack trace

    • org.postgresql.util.PSQLException: ERROR: subquery in FROM must have an alias Hint: For example, FROM (SELECT ...) [AS] foo. Position: 57 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:413) at com.zaxxer.hikari.proxy.PreparedStatementProxy.execute(PreparedStatementProxy.java:44) at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.execute(HikariPreparedStatementProxy.java) at slick.jdbc.StatementInvoker.results(StatementInvoker.scala:39) at slick.jdbc.StatementInvoker.iteratorTo(StatementInvoker.scala:22) at slick.jdbc.Invoker$class.foreach(Invoker.scala:48) at slick.jdbc.StatementInvoker.foreach(StatementInvoker.scala:16) at slick.jdbc.StreamingInvokerAction$class.run(StreamingInvokerAction.scala:22) at slick.jdbc.SQLActionBuilder$$anon$1.run(StaticQuery.scala:100) at slick.jdbc.SQLActionBuilder$$anon$1.run(StaticQuery.scala:100) at slick.backend.DatabaseComponent$DatabaseDef$$anon$2.liftedTree1$1(DatabaseComponent.scala:237) at slick.backend.DatabaseComponent$DatabaseDef$$anon$2.run(DatabaseComponent.scala:237) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    9 times, 1 month ago
    Unknown user
    Once, 4 months ago
    6 times, 7 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    90 more bugmates