| From: | Christopher Browne <cbbrowne(at)sympatico(dot)ca> |
|---|---|
| To: | Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org, PostgreSQL Mailing Lists <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: commit inside a function failing |
| Date: | 2015-01-24 15:26:58 |
| Message-ID: | BLU436-SMTP17078F7243A8AD8C98CC6B3B3370@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
<p dir="ltr">The straightforward answer is that stored functions always run *inside* the context of a preexisting transaction, therefore you cannot request a separate transaction from within a stored function.</p>
<p dir="ltr">What you are asking is fairly deeply impossible.</p>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 280 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sameer Kumar | 2015-01-24 17:08:50 | Re: Postgres seems to use indexes in the wrong order |
| Previous Message | Adrian Klaver | 2015-01-24 15:26:41 | Re: CLOG read problem after pg_basebackup |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Suresh Raja | 2015-01-26 19:58:01 | check if the same function is already running, then exit! |
| Previous Message | Jason Aleski | 2015-01-24 02:36:49 | Re: Better way to compute moving averages? |