shanmugavel muthuvel <shanmugavel.muthu@xxxxxxxxx> wrote: > I have an issue with of "idle transaction" and one select > statement in backend. > How can fix the issue. There wasn't enough detail in the problem statement to make a detailed suggestion. The general suggestion would be to make sure that transactions are never left idle for any significant amount of time. (For example, applications should never wait for user input with a transaction pending.) For more detailed suggestions, please review this for ideas on what people might need to see to provide more specific suggestions: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
