Hello ! a) The idea with to test a RAISE statement with an prefix, could be good. But I am just that new, I could not make it working. I have not understand, where I can issue direct sql statements and it looks like, the RAISE is not possible with plSql: mbtest=# RAISE NOTICE 'mynotice: %', 'hello'; ERROR: syntax error at or near "RAISE" LINE 1: RAISE NOTICE 'mynotice: %', 'hello'; b) Yes, good idea to modify the startup script! Regards++mabra -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Scott Ribe Sent: Thursday, December 02, 2010 8:16 PM To: mabra@xxxxxxxxxxxxxxxxx@manfbraun.de Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Looking for auto starting procedures On Dec 2, 2010, at 11:32 AM, <mabra@xxxxxxxxxxxx> <mabra@xxxxxxxxxxxx> wrote: > > The usual notification from postgreSQL does not allow to write > an [own, better to evaluate] identifier in the syslog. This is > not a matter of the syslog daemon, its on the program which logs. > May be, I have just not found this. Am I missing something you require, or would this do it: raise notice 'mynotice: %', some_id; > An auto running stored procedure would solve the problem, if therewould be > a way to run this procedure on server startup automatically > [as it looks, write another daemon for this]. I've actually wanted that as well ;-) But it's not that hard to arrange for your script that starts the PG server to also run some SQL after the server launch. -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
