pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Boguk Maxim <astar@rambler-co.ru>
To: 'tony' <tony@tgds.net>
To: pgsql-admin@postgresql.org
Subject: Re: maybe off topic JDBC question
Date: Tue, 20 Dec 2005 13:20:10 +0300
Message-ID: <291ABF6CBE162F45B006AFF7AB770B8806F8A7C2@office.rambler.stack.net> (raw )
Try add that into postgresql.conf:
add_missing_from = on
More details look here:
http://www.postgresql.org/docs/8.1/interactive/runtime-config-compatible.htm
l
(
add_missing_from (boolean)
When on, tables that are referenced by a query will be automatically added
to the FROM clause if not already present. This behavior does not comply
with the SQL standard and many people dislike it because it can mask
mistakes (such as referencing a table where you should have referenced its
alias). The default is off. This variable can be enabled for compatibility
with releases of PostgreSQL prior to 8.1, where this behavior was allowed by
default.
Note that even when this variable is enabled, a warning message will be
emitted for each implicit FROM entry referenced by a query. Users are
encouraged to update their applications to not rely on this behavior, by
adding all tables referenced by a query to the query's FROM clause (or its
USING clause in the case of DELETE).
)
> -----Original Message-----
> From: tony [mailto:tony@tgds.net]
> Sent: Tuesday, December 20, 2005 12:25 PM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] maybe off topic JDBC question
>
>
> Ok this is probably a JDBC thing but as many admins seem to be running
> webapps and it is a version migration problem I shall ask here:
>
> I have migrated the backend from 7.2.1 to 8.1.1
> Most of the JSPs work just fine several others don't
>
> §§§§§§§§§§§§§§§§§
>
> org.postgresql.util.PSQLException: ERREUR: Entrée manquante de la
> clause FROM pour la table «individu»
>
> (translation: missing entry in the FROM clause of table...)
>
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
> QueryExecu
> torImpl.java:1512)
>
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryE
> xecutorImp
> l.java:1297)
>
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutor
> Impl.java:
> 188)
>
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJd
> bc2Stateme
> nt.java:430)
>
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(A
> bstractJdb
> c2Statement.java:346)
>
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(Abstr
> actJdbc2St
> atement.java:250)
>
> org.apache.jsp.contact.fiche_005findividu_005fintra_jsp._jspSe
> rvice(org.
> apache.jsp.contact.fiche_005findividu_005fintra_jsp:71)
>
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>
> org.apache.jasper.servlet.JspServletWrapper.service(JspServlet
> Wrapper.ja
> va:322)
>
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet
> .java:314)
>
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>
> §§§§§§§§§§§§§§§§§§
>
> OK so far so good, now the crunch - I have a newer version of
> one of the
> broken pages which uses the exact same JDBC connection code and it
> works. The only modifications in the new page are use of style sheets
> for layout instead of tables...
>
> I have run the query from the JSP in pgaccess and it works just fine.
>
> Tomcat was also updated from 4 to 5.5 and I have the latest
> postgresql.jar for JDK1.5
>
> Any thoughts?
>
> Cheers
>
> Tony
> --
> Tony Grant
> www.tgds.net - vente d'ordinateurs mini-itx en ligne
> www.tgds.net/epiaix1.html - A fedora Core 4 based live CD for
> VIA Epia-M
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
view thread (3+ messages) latest in thread
Message-ID: <291ABF6CBE162F45B006AFF7AB770B8806F8A7C2@office.rambler.stack.net>
Permalink: ../291ABF6CBE162F45B006AFF7AB770B8806F8A7C2@office.rambler.stack.net/
Also on: postgresql.org/message-id/291ABF6CBE162F45B006AFF7AB770B8806F8A7C2@office.rambler.stack.net
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: astar@rambler-co.ru, tony@tgds.net
Subject: Re: maybe off topic JDBC question
In-Reply-To: <291ABF6CBE162F45B006AFF7AB770B8806F8A7C2@office.rambler.stack.net>
References: <291ABF6CBE162F45B006AFF7AB770B8806F8A7C2@office.rambler.stack.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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