| From: | Alex Pilosov <alex(at)pilosoft(dot)com> |
|---|---|
| To: | Daniel Åkerud <zilch(at)home(dot)se> |
| Cc: | PostgreSQL-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Transactions within a function |
| Date: | 2001-07-06 13:47:17 |
| Message-ID: | Pine.BSO.4.10.10107060946250.7004-100000@spider.pilosoft.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice pgsql-sql |
On Fri, 6 Jul 2001, [iso-8859-1] Daniel kerud wrote:
> Do the BEGIN and END in a function also indicate that it is done in a
> transaction? Or can you put another BEGIN TRANSACTION; END
> TRANSACTION; in there?
No. Functions cannot start/stop transactions, as postgresql does not
currently support nested transactions. BEGIN/END are pascalish/adaish
things identical to { and } in C.
-alex
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-07-06 14:22:18 | Re: Transactions within a function |
| Previous Message | Doug McNaught | 2001-07-06 13:32:28 | Re: Transactions within a function |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-07-06 14:22:18 | Re: Transactions within a function |
| Previous Message | Doug McNaught | 2001-07-06 13:32:28 | Re: Transactions within a function |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-07-06 14:18:32 | Re: While Using COPY COMMAND ... |
| Previous Message | postgresql | 2001-07-06 13:46:58 | finding current oid |