Re: [GENERAL] Looking for auto starting procedures

2010-12-05 Thread mabra
tried yet]. Thanks for the pointers, I have yet not heard about PGQ and it looks like something I missed on Sql Server! Will study this! For logging:I think, I have all rights, but not postgresql configured to log to syslog. Much thanks! br++mabra -Original Message- From: pgsql-general-ow

Re: [GENERAL] Looking for auto starting procedures

2010-12-02 Thread mabra
#x27;debug' ;-) ]. Will just configure the logging tomorrow, that way, that the stronger ones are going to the syslog. br++mabra -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Scott Ribe Sent: Thursday, December 02, 2010

Re: [GENERAL] Looking for auto starting procedures

2010-12-02 Thread mabra
Hello ! Rellay good;I see, the track is not wong ;-) But currently, I stuck in 8.4 [debian/squeeze]. I'll try to write a function and leran if and how I can call it. Thanks a lot! br++mabra -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-gener

Re: [GENERAL] Looking for auto starting procedures

2010-12-02 Thread mabra
otice: %', '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-ow...@postgresql.org [mailto:pgsql-general-

Re: [GENERAL] Looking for auto starting procedures

2010-12-02 Thread mabra
] 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. Wished, my migration would a bit easier ;-) br++mabra -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org

[GENERAL] Looking for auto starting procedures

2010-12-01 Thread mabra
running procedures, which do some work. On Sql Server, I can use "auto-start stored procedures". Is there anything like this in postgresql, or what can I do? And, is it just possible, to put a message to the syslog and with my own identification string? Thanks so far! br++mabra --

Re: [GENERAL] Instructions/status of modpglogger

2010-11-12 Thread mabra
Hi ! Thank you. But this is out my current linux experience ;-) I'll look for PGLOGD or let apache lo to a pipe and write the pipe receiver with mono [and NpgSql]. Thanks! ++mabra -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresq

[GENERAL] Instructions/status of modpglogger

2010-11-11 Thread mabra
Hi All ! I just started with postgres and wish to use a postgres db as a logging destination for my apache webserver in my debian environment [this was not the reason to start with postgres]. Does someone, if this works [thre is no package in my distribution]? Any tips would be great! br++mabra