Re: [SQL] ALTER USER abc PASSWORD - what's going on ???

2013-04-18 Thread SEKA Bruno-Emmanuel
OK then.. Sent from my Samsung Galaxy Note. On 18 Apr 2013 11:22, "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... but upon connecting postgres compla

Re: [SQL] ALTER USER abc PASSWORD - what's going on ???

2013-04-18 Thread SEKA Bruno-Emmanuel
Which version of postgresql.? Sent from my Samsung Galaxy Note. On 18 Apr 2013 11:01, "Marcin Krawczyk" wrote: > Hi, > > I can't change the pass for my user. When I invoke ALTER USER abc PASSWORD > newpassword > it changes ok but then I can't login with my newpassword... > > It says autheticatio