Re: Looking for auto starting procedures - Mailing list pgsql-general

From Scott Ribe
Subject Re: Looking for auto starting procedures
Date
Msg-id 3DC41876-D07E-4345-8095-5F36DD5CDE08@elevated-dev.com
Whole thread Raw
In response to Re: Looking for auto starting procedures  (<mabra@manfbraun.de>)
Responses Re: Looking for auto starting procedures  (<mabra@manfbraun.de>)
List pgsql-general
On Dec 2, 2010, at 11:32 AM, <mabra@manfbraun.de> <mabra@manfbraun.de> 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
alsorun some SQL after the server launch. 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: How to find correct locale name for CREATEDATABASE
Next
From: Radosław Smogura
Date:
Subject: Re: Full Text Partial Match at begining