pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Magnus Hagander <mha@sollentuna.net>
To: Ross J. Reedstrom <reedstrm@rice.edu>
To: sbelow <sbelow@dundee.net>
Cc: pgsql-sql@postgresql.org
Subject: RE: firehouse
Date: Sat, 23 Jun 2001 18:39:07 +0200
Message-ID: <81124B76C0CF364EBAC6CD213ABEDEF701AA39@ARGON.edu.sollentuna.se> (raw)

> On Wed, Jun 20, 2001 at 07:37:39PM +0000, sbelow wrote:
> > getting this error "Transaction cannot start while in 
> firehouse mode." I
> > can't find in the books what this is trying to tell me.
> > new at dbs.
> 
> That message is not coming from PostgreSQL, I've grepped the 
> source tree:
> 
> $ find . -name \*.[chyl] | xargs grep -i 'fireh'
> $ 
> 
> What's your software environment? The error must be coming from some
> other layer.

"firehose cursor" is Microsoft lingo for "server-side,
forward-scrolling, read-only cursor".
The solution is to change cursor mode if you need to be able to start a
transaction, or make sure that *all* recordsets associated with the
connectino are closed before you execute the .BeginTrans method.
See example 2 in
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnproas
p/html/tipsforworkingwithcursors.asp



//Magnus



view thread (4+ messages)

Message-ID: <81124B76C0CF364EBAC6CD213ABEDEF701AA39@ARGON.edu.sollentuna.se>
Permalink:  ../81124B76C0CF364EBAC6CD213ABEDEF701AA39@ARGON.edu.sollentuna.se/
Also on:    postgresql.org/message-id/81124B76C0CF364EBAC6CD213ABEDEF701AA39@ARGON.edu.sollentuna.se

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: mha@sollentuna.net, reedstrm@rice.edu, sbelow@dundee.net
  Subject: RE: firehouse
  In-Reply-To: <81124B76C0CF364EBAC6CD213ABEDEF701AA39@ARGON.edu.sollentuna.se>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox