Good day! A little help, please….
Postgresql 8.3
pgAdmin III v.1.8.4
Creating a new function, or modifying an existing function to:
CREATE OR REPLACE FUNCTION "sp_SetScenario"(scen character varying) RETURNS void AS
$BODY$DECLARE
sqlStatement varchar(500);
BEGIN
SET sqlStatement = 'ALTER USER postgres WITH DEFAULT_SCHEMA = $1';
EXEC(sqlStatement);
END;
$BODY$
LANGUAGE 'sql' VOLATILE
COST 100;
Results in a pop-up message:
pgAdminIII
An error has occurred
ERROR: syntax error at or near “varchar”
LINE3: sqlStatement varchar(500);
^
Thank you for your time!
Jim
______________________________________________________________________
NOTICE: This communication and any attachments ("this message") may contain confidential information for the sole use of the intended recipient(s). Any unauthorized use, disclosure, viewing, copying, alteration, dissemination or distribution of, or reliance on this message is strictly prohibited. If you have received this message in error, or you are not an authorized recipient, please notify the sender immediately by replying to this message, delete this message and all copies from your e-mail system and destroy any printed copies.