Not able to access SELECT * FROM ao_60db71_issueranking table from postgres database

[Tushar]

When I write the following query in postgres Dataase, it gives me error that ao_60db71_issueranking table does not exist

SELECT * FROM ao_60db71_issueranking where issue_id in (SELECT id FROM jiraissue)

Please help.

[rrudnicki]

Hi Tushar, 

With AO Tables, usually I need to put the table's name between " ". For example:

confluence573=# select * from AO_7CDE43_RECIPIENT;

ERROR:  relation "ao_7cde43_recipient" does not exist

LINE 1: select * from AO_7CDE43_RECIPIENT;

                      
confluence573=# 

confluence573=# 

confluence573=# 

confluence573=# select * from "AO_7CDE43_RECIPIENT";

 ID | INDIVIDUAL | NOTIFICATION_ID | PARAM_DISPLAY | PARAM_VALUE | SERVER_ID | TYPE 

----+------------+-----------------+---------------+-------------+-----------+------

(0 rows)
confluence573=#

Regards, 

Renato Rudnicki

[Boris Berenberg]

Try AO_60DB71_ISSUERANKING instead.