Re: [PATCHES] Documentation: ALTER ROLE - no password

2008-04-30 Thread Alvaro Herrera
Andreas 'ads' Scherbaum wrote:
 
 Hello,
 
 i've seen the question how to remove a password now several times in
 the last weeks. Attached is a small patch which add a new example for
 the ALTER ROLE documentation.

Applied, thanks.

-- 
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

-- 
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches


[PATCHES] Documentation: ALTER ROLE - no password

2008-04-29 Thread Andreas 'ads' Scherbaum

Hello,

i've seen the question how to remove a password now several times in
the last weeks. Attached is a small patch which add a new example for
the ALTER ROLE documentation.


Kind regards

-- 
Andreas 'ads' Scherbaum
German PostgreSQL User Group
--- alter_role.sgml.orig	2007-09-03 20:46:29.0 +0200
+++ alter_role.sgml	2008-04-30 02:02:00.0 +0200
@@ -218,6 +218,14 @@
   /para
 
   para
+   Remove a role's password:
+
+programlisting
+ALTER ROLE davide WITH PASSWORD NULL;
+/programlisting
+  /para
+
+  para
Change a password expiration date, specifying that the password
should expire at midday on 4th May 2015 using
the time zone which is one hour ahead of acronymUTC/:

-- 
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches