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.
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
Try AO_60DB71_ISSUERANKING instead.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.