pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedstrange error message
4+ messages / 3 participants
[nested] [flat]
* strange error message
@ 2000-07-18 06:29 Gerhard Dieringer <DieringG@eba-haus.de>
0 siblings, 0 replies; 4+ messages in thread
From: Gerhard Dieringer @ 2000-07-18 06:29 UTC (permalink / raw)
To: " <"<pgsql-sql@postgresql.org>
Hi all,
I'm sure I found somewhere in the docs, that postgreSQL 7.0 accepts ANSI-SQL style join syntax, but when I try:
SELECT ta.a, tb.b FROM taba ta INNER JOIN tabb tb ON ta.c = tb.c;
I get the strange message:
ERROR: transformExpr: does not know how to transform node 501 (internal error)
Is my syntax wrong or is this a bug in the parser? I'm using 7.0.0
Gerhard
^ permalink raw reply [nested|flat] 4+ messages in thread
* strange error message
@ 2011-11-25 07:20 Uwe Bartels <uwe.bartels@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Uwe Bartels @ 2011-11-25 07:20 UTC (permalink / raw)
To: pgsql-sql
Hi,
I've got a strange error message in our java application.
the only reference to this message i find in
http://mingo.info-science.uiowa.edu/eichmann/courses/database/Postgres/programmer.pdf<https://web...;.
but I still don't know how to solve this or even what the source od this
error is.
currently I don't have the executed sql yet. I'm trying to get this.
Any Idea what that could be?
ERROR JDBCTransaction:124 - JDBC commit failed
*org.postgresql.util.PSQLException: ERROR: bogus varno: 65001*
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:671)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:691)
at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$ConnectionHandler.invoke(AbstractJdbc23PooledConnection.java:352)
at $Proxy24.commit(Unknown Source)
at
org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)
at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
...
Thanks,
Uwe
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: strange error message
@ 2011-11-25 16:43 Tom Lane <tgl@sss.pgh.pa.us>
parent: Uwe Bartels <uwe.bartels@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2011-11-25 16:43 UTC (permalink / raw)
To: Uwe Bartels <uwe.bartels@gmail.com>; +Cc: pgsql-sql
Uwe Bartels <uwe.bartels@gmail.com> writes:
> I've got a strange error message in our java application.
> ERROR JDBCTransaction:124 - JDBC commit failed
> *org.postgresql.util.PSQLException: ERROR: bogus varno: 65001*
This is a symptom of some kind of planner error. If you are not
running the latest minor release of your Postgres branch, update
and see if it goes away. If not, please file a bug report with
sufficient information to reproduce the problem by hand (ie, the
problem query plus schema+data sufficient to run it against).
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: strange error message
@ 2011-11-25 17:07 Uwe Bartels <uwe.bartels@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Uwe Bartels @ 2011-11-25 17:07 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
Hi Tom,
Cool. Thanks for your answer.
Best Regards,
Uwe
On 25 November 2011 17:43, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Uwe Bartels <uwe.bartels@gmail.com> writes:
> > I've got a strange error message in our java application.
>
> > ERROR JDBCTransaction:124 - JDBC commit failed
> > *org.postgresql.util.PSQLException: ERROR: bogus varno: 65001*
>
> This is a symptom of some kind of planner error. If you are not
> running the latest minor release of your Postgres branch, update
> and see if it goes away. If not, please file a bug report with
> sufficient information to reproduce the problem by hand (ie, the
> problem query plus schema+data sufficient to run it against).
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2011-11-25 17:07 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-07-18 06:29 strange error message Gerhard Dieringer <DieringG@eba-haus.de>
2011-11-25 07:20 strange error message Uwe Bartels <uwe.bartels@gmail.com>
2011-11-25 16:43 ` Tom Lane <tgl@sss.pgh.pa.us>
2011-11-25 17:07 ` Uwe Bartels <uwe.bartels@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox