Обсуждение: Cursors out of a transaction

Hi.

    Why can't I use a cursor out of a transaction block? I really need to
do it, since I'm working with a great amount of data, and can't do
simply a  'select' and get all the results. And this is an interactive
process, which may be interrupted at any time, and I want all the
changes to be kept.

--
    Greetings.
    David Prieto.
    mailto:davidp@arrakis.es

I'm trying to  revoke some permisios to an user in a table, but It isn't working.

The commands said me that it changed the rights but the user still can do the
operation.

Which conditions do I need  to make revoke   works?