| From: | wsmuir(at)islandnet(dot)com |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Locks in functions |
| Date: | 2001-04-12 22:13:37 |
| Message-ID: | 010412151337@islandnet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have been reading in the dox that pgsql does not support cursors
from inside any of the interfaces, well the ones I care about anyways
which are PL and SPI...
I'm using SPI to spawn an external process to run... (image
manipulator), and I want to be able to control concurrent executions
of the process. I figure setting up a semaphore using an exclusive
record lock is my best bet...
Can anyone tell me if there is a way of doing this, maintaining a
lock
while its away processing while using either PL/pgsql or SPI...
I mention the cursors because it is clear that they cannot be done
without a patch, but it is unclear whether locks and
transactions/commits/rollbacks are supported here.
Thankyou..
scott
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin S. | 2001-04-13 03:20:29 | Address already in use? |
| Previous Message | Peter Eisentraut | 2001-04-12 20:40:28 | Re: using result as part of regular expression |