pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedfirehouse
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