Values inside rolvaliduntil of pg_authid

From: Frank Lanitz <frank(at)frank(dot)uvena(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Values inside rolvaliduntil of pg_authid
Date: 2012-03-26 09:32:17
Message-ID: 4F7037A1.8060204@frank.uvena.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi folks,

I'm currently doing some checks for users. During this I've found inside
pg_authid.rolvaliduntil a couple of values I wasn't able to figure out
via documentation, whether they are valid.... Maybe you can help me out
helping whether these are valid dates and what is postgres interpreting
them:

- infinity (I assume it's treaded as NULL inside this column ->
unlimited password)
- 1970-01-01 00:00:00+01 (UNIX timestamp 0. I have no f. bloody idea here)

(I'm running 8.4 here)

cheers,
Frank

Browse pgsql-general by date

  From Date Subject
Next Message and 2012-03-26 09:32:50 loading a function from a file
Previous Message Maximilian Tyrtania 2012-03-26 09:22:24 compilation info without pg_config