Why?

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