Skip site navigation (1) Skip section navigation (2)

Re: BUG ? ... CURSOR AS VIEW ... MOVE ... CRASH

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nabil Sayegh <nsmail(at)sayegh(dot)de>
Cc: postgresql <pgsql-novice(at)postgresql(dot)org>
Subject: Re: BUG ? ... CURSOR AS VIEW ... MOVE ... CRASH
Date: 2001-04-20 17:50:16
Message-ID: 27144.987789016@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Nabil Sayegh <nsmail(at)sayegh(dot)de> writes:
> The following script crashes the backend (when run with psql).

Yes, this is a bug.  I can't get excited about fixing it though,
because there are a huge pile of other bugs associated with changing
fetch directions in complex queries.  The amount of work needed to make
the world safe for this sort of thing is far out of proportion to the
benefit.  Maybe someday someone will get around to it --- but we have
a lot of higher-priority problems...

> BTW: Is it o.k. to use MOVE to re-use a query ? Or is there no speed
> benefit ?

There isn't any real speed benefit; besides, what's the point of
refetching tuples you already fetched?  If you want random access
to a query result, libpq does that just fine on the client side.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Bob WhitehouseDate: 2001-04-20 19:52:25
Subject: Returning function results...
Previous:From: Nabil SayeghDate: 2001-04-20 15:46:38
Subject: BUG ? ... CURSOR AS VIEW ... MOVE ... CRASH

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group