Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UStPO-0002Fl-6s for pgsql-sql@arkaria.postgresql.org; Thu, 18 Apr 2013 18:18:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UStPN-0006oB-FR for pgsql-sql@arkaria.postgresql.org; Thu, 18 Apr 2013 18:18:09 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UStPM-0006np-PS for pgsql-sql@postgresql.org; Thu, 18 Apr 2013 18:18:08 +0000 Received: from 88-190-26-230.rev.dedibox.fr ([88.190.26.230] helo=sd-30687.dedibox.fr) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UStPJ-0003AD-T1 for pgsql-sql@postgresql.org; Thu, 18 Apr 2013 18:18:08 +0000 Received: from [192.168.10.5] (AMontsouris-652-1-114-64.w83-202.abo.wanadoo.fr [83.202.173.64]) by sd-30687.dedibox.fr (Postfix) with ESMTPSA id B372D64270E; Thu, 18 Apr 2013 20:18:03 +0200 (CEST) Message-ID: <1366309083.3105.0.camel@localhost.localdomain> Subject: Re: ALTER USER abc PASSWORD - what's going on ??? From: Guillaume Lelarge To: Marcin Krawczyk Cc: "pgsql-sql@postgresql.org" Date: Thu, 18 Apr 2013 20:18:03 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.6.4 (3.6.4-3.fc18) Mime-Version: 1.0 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.9 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org On Thu, 2013-04-18 at 13:21 +0200, Marcin Krawczyk wrote: > I figured it out... when changing role from pgAdmin, it has a default VALID > UNTIL 1970 set and after confirming changes it just made my abc user > account invalid... FYI, this pgAdmin bug has been fixed. The fix will be available in the next minor release. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql