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-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Adrian Klaver Sent: Thursday, December 02, 2010 9:35 PM To: mabra@xxxxxxxxxxxx Cc: @manfbraun.demabra@xxxxxxxxxxxx'; " Subject: Re: Looking for auto starting procedures On 12/02/2010 12:27 PM, mabra@xxxxxxxxxxxx wrote: > 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'; > It is available in plpgsql: http://www.postgresql.org/docs/9.0/interactive/plpgsql-errors-and-messages.h tml If you are running 9.0+ you can use DO to run it at the psql prompt: http://www.postgresql.org/docs/9.0/interactive/sql-do.html -- Adrian Klaver adrian.klaver@xxxxxxxxx -- 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
