Re: raise statement, how to do multi-line message

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: raise statement, how to do multi-line message
Date: 2011-02-09 12:16:53
Message-ID: iiu0jl$3dt$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 2011-02-06, Leon Starr <leon_starr(at)modelint(dot)com> wrote:

> I tried this, but it didn't work:
>
> raise exception 'Delivery specification for Monitored Event' || '[%:%:%] and Notification Template [%] does not exist.',
> p_event, p_monitor, p_subscriber, p_template;

Raise is "special". The first argument only looks like a string.

--
⚂⚃ 100% natural

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message l1 2011-02-09 15:36:46 how to get logger to not break up syslog messages
Previous Message Jasen Betts 2011-02-09 12:00:14 Re: Backing up several PostgreSQL databases