From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: SPI: ERROR: no snapshot has been set |
Date: | 2005-08-17 18:25:43 |
Message-ID: | 20050817182543.GC30579@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
For future reference, I got around this error (no snapshot has been
set) by removing the use of SPI and just using heap_open /
heap_beginscan / heap_endscan / heap_close. It's only slightly more
code but it works irrespective of the state of the backend.
Have a nice day,
On Sat, Aug 13, 2005 at 03:59:56PM +0200, Martijn van Oosterhout wrote:
> Good guess, I am inside a type input function trying to use SPI. My
> questions are:
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2005-08-17 18:32:58 | Re: pl/Ruby, deprecating plPython and Core |
Previous Message | Alvaro Herrera | 2005-08-17 18:10:23 | Crash while trying to log in with nonexistent role |