On_error_stop

From: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: On_error_stop
Date: 2007-07-03 06:25:20
Message-ID: 00a601c7bd3a$f20dec20$170211ac@LIONKING.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello All,

I want to run few DDL's from scripts and want the script to halt if any error ocuurs, this can be done by on_error_stop

But what I want to do is to display a message something like

If on_error_stop =1
{
echo "DDL failed";
exit();
}

else "DDL passed";

end

is there any way to do this?

Thanks in advance
Ashish...

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message callewaert.nico 2007-07-03 06:48:43 Books on server programming
Previous Message Andrew Maclean 2007-07-03 03:58:02 Re: [NOVICE] Recursive relationship - preventing cross-index entries.