| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | mario(dot)splivalo(at)mobart(dot)hr |
| Cc: | Jaime Casanova <systemguards(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Changing the transaction isolation level within the |
| Date: | 2006-01-26 08:41:37 |
| Message-ID: | 43D88B41.9040904@logix-tt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi, Mario,
Mario Splivalo wrote:
>>you need to set the transaction level after the begin and before every
>>other statement... after the begin you have a select that invoke your
>>function so that set is not the first statement...
>
> But I can't do that inside of a function, right?
Right, as you need a SELECT to actually execute your function, so the
transaction commands inside the function are invoced _after_ the first
SELECT began execution.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schaber | 2006-01-26 09:42:54 | Re: Changing the transaction isolation level within the stored |
| Previous Message | Mario Splivalo | 2006-01-26 07:11:03 | Re: Changing the transaction isolation level within the |