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

    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
    Location
    Vienna
    Posts
    400

    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
    http://www.postgresql.org
    --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
  •