Hi!
Why does not work this?
CREATE FUNCTION PWDCHG () RETURNS OPAQUE AS '
BEGIN
ALTER USER utest WITH PASSWORD ''ptest'';
END;
' LANGUAGE 'plpgsql';
select PWDCHG();
ERROR: typeidTypeRelid: Invalid type - oid = 0
and this other?
CREATE FUNCTION PWDCHG () RETURNS bool AS '
BEGIN
ALTER USER utest WITH PASSWORD ''ptest'';
RETURN ''t'';
END;
' LANGUAGE 'plpgsql';
select PWDCHG();
ERROR: copyObject: don't know how to copy 646
Regards,
Juan Carlos.
______________________________________________
FREE Personalized Email at Mail.com
Sign up at http://www.mail.com/?sr=signup