| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Bohdan Linda <bohdan(dot)linda(at)seznam(dot)cz> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Partial commit within the trasaction |
| Date: | 2005-09-08 12:53:47 |
| Message-ID: | 20050908125347.GB68650@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Sep 08, 2005 at 01:23:56PM +0200, Bohdan Linda wrote:
> plpgsq code does time intensive data manipulation + database vacuuming.
> This data manipulation is splitted logically into several steps. After
> each step I would like to give a message to the status table, what the
> procedure is performing.
>
> Currently I pass the information to the table via insert, but this is also
> the limitation. I would like to allow another user see the progress of the
> current pgplsql procedure, but no insert is commited, till procedure ends.
>
> How this can be solved?
One way would be to use contrib/dblink to open another connection
to the database so the status messages could be inserted in a
separate transaction.
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pobox@verysmall.org | 2005-09-08 13:04:32 | Re: change column data type from smallint to integer |
| Previous Message | Axel Straschil | 2005-09-08 12:20:24 | Re: EMS PostgreSQL Manager vs. TheKompany DataArchitect |