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

GitHub | EndeNeu | 4 months ago
  1. 0

    "subquery in FROM must have an alias" although an alias was defined

    GitHub | 4 months ago | EndeNeu
    org.postgresql.util.PSQLException: ERROR: subquery in FROM must have an alias Hint: For example, FROM (SELECT ...) [AS] foo. Position: 57
  2. 0

    PlainSQL: `sqlu` generates wrong DDL sql?

    GitHub | 2 years ago | tminglei
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1" Position: 88
  3. 0

    PSQLException; No function matches given name and argument types

    Stack Overflow | 1 year ago | user1011376
    org.postgresql.util.PSQLException: ERROR: function create_new_user(bigint, character varying, character varying, character varying, character varying, unknown, character) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 15
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ERROR c.t.t.d.e.DefaultExecutorFactory - System executor exception

    GitHub | 1 year ago | zarmack
    com.torodb.torod.core.exceptions.ToroRuntimeException: java.lang.RuntimeException: org.jooq.exception.DataAccessException: SQL [{ ? = call "public"."reserve_doc_ids"(?, ?) }]; ERROR: function public.reserve_doc_ids(character varying, integer) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 15
  6. 0

    Mapping java.lang.String type to Postgres JSON Type

    Stack Overflow | 11 months ago | charlie f
    org.postgresql.util.PSQLException: ERROR: column "state" is of type json but expression is of type character varying Hint: You will need to rewrite or cast the expression. Position: 38

  1. silex 16 times, last 3 weeks ago
  2. silex 1 times, last 5 months ago
10 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.execute
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:413)
    6 frames
  3. HikariCP-java6
    HikariPreparedStatementProxy.execute
    1. com.zaxxer.hikari.proxy.PreparedStatementProxy.execute(PreparedStatementProxy.java:44)
    2. com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.execute(HikariPreparedStatementProxy.java)
    2 frames
  4. slick.jdbc
    SQLActionBuilder$$anon$1.run
    1. slick.jdbc.StatementInvoker.results(StatementInvoker.scala:39)
    2. slick.jdbc.StatementInvoker.iteratorTo(StatementInvoker.scala:22)
    3. slick.jdbc.Invoker$class.foreach(Invoker.scala:48)
    4. slick.jdbc.StatementInvoker.foreach(StatementInvoker.scala:16)
    5. slick.jdbc.StreamingInvokerAction$class.run(StreamingInvokerAction.scala:22)
    6. slick.jdbc.SQLActionBuilder$$anon$1.run(StaticQuery.scala:100)
    7. slick.jdbc.SQLActionBuilder$$anon$1.run(StaticQuery.scala:100)
    7 frames
  5. slick.backend
    DatabaseComponent$DatabaseDef$$anon$2.run
    1. slick.backend.DatabaseComponent$DatabaseDef$$anon$2.liftedTree1$1(DatabaseComponent.scala:237)
    2. slick.backend.DatabaseComponent$DatabaseDef$$anon$2.run(DatabaseComponent.scala:237)
    2 frames
  6. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    3. java.lang.Thread.run(Thread.java:745)
    3 frames