"Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> writes:
> "Egyd Csaba" <csegyud(at)vnet(dot)hu> writes
>> I know the VALID UNTIL clause of CREATE USER command, but it is about the
>> password only.
>> I think something similar but regarding the whole user account.
> It is not about password only. Once current date is beyond the valid date
> you set, the user can never get authorized ok anymore.
He's right, you're not: that check is only applied in the
password-based authorization path.
This has always seemed a bit bogus to me too --- would not object to
a well-thought-out patch to change it.
regards, tom lane