Re: Trigger that spawns forked process - Mailing list pgsql-general

From Tom Lane
Subject Re: Trigger that spawns forked process
Date
Msg-id 760.1115667527@sss.pgh.pa.us
Whole thread Raw
In response to Trigger that spawns forked process  (Christopher Murtagh <christopher.murtagh@mcgill.ca>)
Responses Re: Trigger that spawns forked process
List pgsql-general
Christopher Murtagh <christopher.murtagh@mcgill.ca> writes:
>  I would like to write a trigger or function that spawns a forked
> process so that the transaction is considered 'complete' to the client,
> but continues to perform more work.

It's not very clear what you are hoping to have the forked process do,
but if it's supposed to be another backend, forget it --- won't work.
See this thread:
http://archives.postgresql.org/pgsql-sql/2005-04/msg00329.php

            regards, tom lane

pgsql-general by date:

Previous
From: "Mohan, Ross"
Date:
Subject: Re: Clustering Database Servers
Next
From: Scott Marlowe
Date:
Subject: Re: Clustering Database Servers