--On 9. Juli 2013 22:05:20 +0000 [email protected] wrote:
I have found that if you change the password in the USER MAPPING, that postgres_fdw will not use it unless the current password fails or you close and re-open your postgres connection. I found this while testing to see if the USER MAPPING's supports MD5 passwords and they appeared to until the next day when I found that they no longer worked because I had closed and re-opened my connection.
Hmm i don't think that's a bug. It's because the postgres_fdw caches the connection within your local session, reusing it for any subsequent foreign table access.
The second error that I found is in the documentation of ALTER USER MAPPING. It incorrectly says how to update a users password.
It could be misread, i agree. Attached is a small doc patch to address this against HEAD.
--
Thanks
Bernd
user_mapping_doc.patch
Description: Binary data
-- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
