BUG #7875: org.postgresql.util.PSQLException: ERROR: column reference "e_raci_obj" is ambiguous

[s***@gmail.com]

The following bug has been logged on the website:

Bug reference: 7875
Logged by: senthil
Email address: ***@gmail.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

[Euler Taveira]

Post by s***@gmail.com
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
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.