Re: virtualxid,relation lock

shanmugavel muthuvel <shanmugavel(dot)muthu(at)gmail(dot)com> 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