pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
firehouse
4+ messages / 4 participants
[nested] [flat]

* firehouse
@ 2001-06-20 19:37 sbelow <sbelow@dundee.net>
  2001-06-22 15:17 ` Re: firehouse Ross J. Reedstrom <reedstrm@rice.edu>
  2001-06-22 17:04 ` Re: firehouse Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 2 replies; 4+ messages in thread

From: sbelow @ 2001-06-20 19:37 UTC (permalink / raw)
  To: pgsql-sql

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.
Thanks for any help
        Steve.





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: firehouse
  2001-06-20 19:37 firehouse sbelow <sbelow@dundee.net>
@ 2001-06-22 15:17 ` Ross J. Reedstrom <reedstrm@rice.edu>
  1 sibling, 0 replies; 4+ messages in thread

From: Ross J. Reedstrom @ 2001-06-22 15:17 UTC (permalink / raw)
  To: sbelow <sbelow@dundee.net>; +Cc: pgsql-sql

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.

Ross



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: firehouse
  2001-06-20 19:37 firehouse sbelow <sbelow@dundee.net>
@ 2001-06-22 17:04 ` Bruce Momjian <pgman@candle.pha.pa.us>
  1 sibling, 0 replies; 4+ messages in thread

From: Bruce Momjian @ 2001-06-22 17:04 UTC (permalink / raw)
  To: sbelow <sbelow@dundee.net>; +Cc: pgsql-sql

> 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 is not our error message.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* RE: firehouse
@ 2001-06-23 16:39 Magnus Hagander <mha@sollentuna.net>
  0 siblings, 0 replies; 4+ messages in thread

From: Magnus Hagander @ 2001-06-23 16:39 UTC (permalink / raw)
  To: Ross J. Reedstrom <reedstrm@rice.edu>; sbelow <sbelow@dundee.net>; +Cc: pgsql-sql

> 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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2001-06-23 16:39 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-06-20 19:37 firehouse sbelow <sbelow@dundee.net>
2001-06-22 15:17 ` Ross J. Reedstrom <reedstrm@rice.edu>
2001-06-22 17:04 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-06-23 16:39 RE: firehouse Magnus Hagander <mha@sollentuna.net>

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