AC Gomez <antklc(at)gmail(dot)com> writes:
> We do hold the original session open. The problem comes when we change the
> password while that session is open, now the session and the User Mappings
> are out of synch and we have failure.
Well, there's no obvious reason for that to be a problem. As another
respondent said, you need to describe what you're doing in far more
detail if you want useful comments.
regards, tom lane