Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Capturing the result status of an ALTER command in plpgsql

2 views
Skip to first unread message

jared...@yahoo.com

unread,
Aug 18, 2004, 4:38:38 PM8/18/04
to
How does one capture the result status of an ALTER command inside
plpgsql code block?


For example:
-----------------
CREATE OR REPLACE FUNCTION public."Setup_Primary_Keys"()
RETURNS SETOF varchar AS
'DECLARE

BEGIN


ALTER TABLE public."HCM00101" ADD CONSTRAINT "hcm00101-pk" PRIMARY
KEY("CUSTNMBR");
-- Capture Success or Failure here of the ALTER command
IF [how do I determine success here?] THEN
return next \'HCM00101 primary key set\';
ELSE [eat the failure exception here and continue]
return next \'HCM00101 primary key was not set, continuing with more
code below\';
END IF;


....... more code ........
return;


END;'
LANGUAGE 'plpgsql' VOLATILE;
-------------------

0 new messages