Search Postgresql Archives

Separating raise notice lines

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I like to use RAISE NOTICE statements to make sure my functions are working correctly.  I just wrote a trigger function that has the following code:
 
    -- We have a new tender.  Find out who it is.
    select into userRecord * from users where users_key = new.tender_key;
    if not found then
 raise exception 'Could not store furnace tender information; no user has a key of %', new.tender_key;
    else
 raise notice 'User name is % %', userRecord.name, chr(10);
    end if;
    -- Now we can store the information.
    insert into furnace_tender_history (area, tender_name, tender_checknum, signin_time, signin_time_utc)
    values (new.area, userRecord.name, userRecord.check_number, current_timestamp, current_timestamp at time zone 'utc');
    raise notice 'History record should be added%', chr(10)::text;
    return new;
I am trying to insert a carriage return character (chr(10)) in the user name notice so that any subsequent notices will appear on separate lines.  However, when I use a query to update a field that will fire this trigger, the Messages tab contains this:
 
NOTICE:  User name is capsNOTICE:  History record should be added
Query returned successfully: 1 rows affected, 16 ms execution time.
How can I get the notices to appear on separate lines?
 
Thanks very much!
 
RobR


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux