On Sun, Mar 16, 2003 at 12:36:25PM -0500, Tom Lane wrote:
> I'm inclined to leave the code alone. But Alvaro is right that it'd be
> good to point out the 'infinity' option in the CREATE USER and ALTER
> USER man pages. (Doc patch please?)
Attached. (Please correct if it's not good english.)
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Investigación es lo que hago cuando no sé lo que estoy haciendo"
(Wernher von Braun)
Index: doc/src/sgml/ref/alter_user.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/ref/alter_user.sgml,v
retrieving revision 1.24
diff -c -r1.24 alter_user.sgml
*** doc/src/sgml/ref/alter_user.sgml 2003/01/19 00:13:29 1.24
--- doc/src/sgml/ref/alter_user.sgml 2003/03/16 17:57:31
***************
*** 124,130 ****
<listitem>
<para>
The date (and, optionally, the time)
! at which this user's password is to expire.
</para>
</listitem>
</varlistentry>
--- 124,131 ----
<listitem>
<para>
The date (and, optionally, the time)
! at which this user's password is to expire. To set the password
! never to expire, use 'infinity'.
</para>
</listitem>
</varlistentry>
***************
*** 229,234 ****
--- 230,242 ----
the time zone which is one hour ahead of <acronym>UTC</>:
<programlisting>
ALTER USER chris VALID UNTIL 'May 4 12:00:00 1998 +1';
+ </programlisting>
+ </para>
+
+ <para>
+ Make a user valid forever:
+ <programlisting>
+ ALTER USER fred VALID UNTIL 'infinity';
</programlisting>
</para>
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
