"Qingqing Zhou" <zhouqq@xxxxxxxxxxxxxx> writes:
> "Együd Csaba" <csegyud@xxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
