[GENERAL] role passwords and md5()

encryption in pg_hba.conf, the SQL function MD5() returns a different hash. A (shortened) example: CREATE ROLE my_user WITH ENCRYPTED PASSWORD 'my_password'; SELECT * FROM pg_authid WHERE rolname='my_user' AND rolpassword=MD5('my_password'); Any ideas, what to do to make this work? Best regards, Lutz

Re: [GENERAL] Webappication and PostgreSQL login roles

, String password)'? Thanks for your help. Bye, Thorsten Can you not use the username/password as part of the DSN? Regards, Lutz Broedel -- Lutz Broedel Leibniz University of Hannover Institute for Water Quality Waste Management / ISAH Division: Water Resources Management Am Kleinen

[GENERAL] using 'ALTER ROLE' in a function

Dear list, I'm trying to write a PL/pgSQL function that executes some code every time a user changes his/her password. The function is supposed to work like this: CREATE OR REPLACE FUNCTION changePwd(varchar(255)) RETURNS boolean AS $$ DECLARE pwd varchar(255); curr_user