Skip site navigation (1) Skip section navigation (2)

Re: UPDATE with database name alias

From: Vadim Nasardinov <vadimn(at)redhat(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: UPDATE with database name alias
Date: 2005-09-20 12:57:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
On Monday 19 September 2005 18:46, Kris Jurka wrote:
> > JDeveloper use alias to UPDATE, an dthen, what can I do?
> >
> Your only option would be to ajdust the postgresql backend grammar
> to allow an alias.

In practical terms, you're right.

In theory, this may also be addressed by using a wrapper JDBC driver
like P6Spy (but not as buggy) that would sit between the application
and the real PostgreSQL JDBC driver.  The wrapper driver would have
the opportunity to rewrite UPDATE statements in a spec-compliant
manner before passing them on to the real driver.

In response to


pgsql-jdbc by date

Next:From: andresDate: 2005-09-20 14:48:18
Subject: UPDATE with alias - P6Spy on JDeveloper
Previous:From: salman.ashraf@gmail.comDate: 2005-09-20 12:30:20
Subject: org.postgresql.util.PSQLException: The backend has broken the connection.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group