"Qingqing Zhou" <zhouqq@cs.toronto.edu> writes:
> "Egy�d Csaba" <csegyud@vnet.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