Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Auckland, New Zealand

    Unanswered: Finding open cursors/queries

    Hi, I have an application that seems to not be closing a query somewhere, under Oracle I used to use a funky SELECT from a magic system table that listed open cursors, is there something similiar under PostgreSQL? I've looked and looked but can't seem to find anything.

    Failing that, the application in question is a Java/JDBC/Servlet based thing, does anyone know of any way in Java to list what PreparedStatement's might be hanging around?

  2. #2
    Join Date
    Sep 2001

    open cursors

    AFAIK there is no such thing in postgresql
    But in the moment the development process of postgresql ist getting very fast
    I think there will be some cursor improvements in 7.4
    --Postgresql is the only kind of thing--

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts