On Wed, Aug 19, 2009 at 8:23 PM, Dick Visser<visser@xxxxxxxxxx> wrote: > > Is there a way to trigger stuff using NOTIFY/LISTEN, but WITHOUT an > external client doing the magic? Some kind of internal Postgres function > that listens for any changes, and then does the magic itself, without > tying up any 'real' clients for the duration of that magic? What do you mean "tying up"? Even if there was no client an internal process would be "tying up" the same resources as if there was one. In my experience it's a lot more flexible having an external process connecting to the database anyways since it means you can use whatever language you like, whatever libraries you like, etc. You can also use other resources, close and open the connection, start and stop transactions, etc. Anything within the database has a lot more restrictions. -- greg http://mit.edu/~gsstark/resume.pdf -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
