From: | <mabra(at)manfbraun(dot)de> |
---|---|
To: | "'Adrian Klaver'" <adrian(dot)klaver(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Looking for auto starting procedures |
Date: | 2010-12-02 21:53:55 |
Message-ID: | !&!AAAAAAAAAAAYAAAAAAAAAOb5xiPoTM8RjQUAgEiElinCgAAAEAAAAAw86XuU9HdLrjpB56GJm0sBAAAAAA==@manfbraun.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Adrian Klaver
Sent: Thursday, December 02, 2010 9:35 PM
To: mabra(at)manfbraun(dot)de
Cc: @manfbraun(dot)demabra(at)manfbraun(dot)de'; "
Subject: Re: [GENERAL] Looking for auto starting procedures
On 12/02/2010 12:27 PM, mabra(at)manfbraun(dot)de 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(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2010-12-02 22:21:54 | Re: Looking for auto starting procedures |
Previous Message | James B. Byrne | 2010-12-02 21:16:50 | Re: Dumping a table from one database and adding it to another |