| Lists: | pgsql-bugs |
|---|
| From: | senthinil(at)gmail(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #7875: org.postgresql.util.PSQLException: ERROR: column reference "e_raci_obj" is ambiguous |
| Date: | 2013-02-14 08:55:36 |
| Message-ID: | E1U5ubQ-0006EP-RH@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 7875
Logged by: senthil
Email address: senthinil(at)gmail(dot)com
PostgreSQL version: 9.1.0
Operating system: Centos 6.3
Description:
Hi
I have taken a backup of esis database which runs in postgres 8.3.10 and
restored the db in Postgres 9.1.0. When I my web application and access a
module in it, it throws me the application exception :
org.postgresql.util.PSQLException: ERROR: column reference "e_raci_obj" is
ambiguous
Please lemme know how to resolve this issue.
Thanks in advance
Senthil
| From: | Euler Taveira <euler(at)timbira(dot)com> |
|---|---|
| To: | senthinil(at)gmail(dot)com |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #7875: org.postgresql.util.PSQLException: ERROR: column reference "e_raci_obj" is ambiguous |
| Date: | 2013-02-14 17:17:22 |
| Message-ID: | 511D1C22.5000809@timbira.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
On 14-02-2013 06:55, senthinil(at)gmail(dot)com wrote:
> I have taken a backup of esis database which runs in postgres 8.3.10 and
> restored the db in Postgres 9.1.0. When I my web application and access a
> module in it, it throws me the application exception :
> org.postgresql.util.PSQLException: ERROR: column reference "e_raci_obj" is
> ambiguous
>
You don't provide enough information. What is the query? Or is it a function
call? It could be useful to show us the table definition or function body.
I also advise you take a look at the release notes from 8.4 to 9.1.
--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento