From: | <mabra(at)manfbraun(dot)de> |
---|---|
To: | "'mabra(at)manfbraun(dot)demabra(at)manfbraun(dot)de'" |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Looking for auto starting procedures |
Date: | 2010-12-02 20:27:19 |
Message-ID: | !&!AAAAAAAAAAAYAAAAAAAAAOb5xiPoTM8RjQUAgEiElinCgAAAEAAAAOikIIrAkLpHlskj21kK0bABAAAAAA==@manfbraun.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Scott Ribe
Sent: Thursday, December 02, 2010 8:16 PM
To: mabra(at)manfbraun(dot)demabra@manfbraun.de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Looking for auto starting procedures
On Dec 2, 2010, at 11:32 AM, <mabra(at)manfbraun(dot)de> <mabra(at)manfbraun(dot)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 also run some SQL after the server
launch.
--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice
From | Date | Subject | |
---|---|---|---|
Next Message | James B. Byrne | 2010-12-02 20:32:37 | Re: PG84 and SELinux |
Previous Message | Devrim GÜNDÜZ | 2010-12-02 20:23:34 | Re: PG84 and SELinux |