Warning about invalid .pgpass passwords
in [PgSql]
|
Prev: Access violation from palloc, Visual Studio 2005, C-language function
Next: [HACKERS] walreceiver is uninterruptible on win32
From: Tom Lane on 11 Mar 2010 18:38 Bruce Momjian <bruce(a)momjian.us> writes: >>>> ERRCODE_INVALID_PASSWORD_SPECIFICATION BTW, why not just "ERRCODE_INVALID_PASSWORD"? The extra word doesn't seem to promote anything except carpal tunnel syndrome. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Tom Lane on 11 Mar 2010 18:40 Bruce Momjian <bruce(a)momjian.us> writes: > + #define ERRCODE_INVALID_PASSWORD_SPECIFICATION MAKE_SQLSTATE('2','8', '0','0','1') Oh, another thought: you're infringing on SQL-committee-controlled code space there. Probably 28P01 would be a safer choice. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Bruce Momjian on 11 Mar 2010 19:42 Tom Lane wrote: > Bruce Momjian <bruce(a)momjian.us> writes: > > + #define ERRCODE_INVALID_PASSWORD_SPECIFICATION MAKE_SQLSTATE('2','8', '0','0','1') > > Oh, another thought: you're infringing on SQL-committee-controlled code > space there. Probably 28P01 would be a safer choice. OK, updated patch with code "28P01", and I shorted the name (now ERRCODE_INVALID_PASSWORD). I thought carpal tunnel was the goal of these error codes. ;-) -- Bruce Momjian <bruce(a)momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do
From: Robert Haas on 11 Mar 2010 21:51 On Thu, Mar 11, 2010 at 4:19 PM, Bruce Momjian <bruce(a)momjian.us> wrote: > $ sql -h localhost test > psql: FATAL: password authentication failed for user "postgres" > password retrieved from .pgpass I find this not quite explicit enough for my taste. Maybe something like this? the failing password was retrieved from .pgpass ....Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Bruce Momjian on 11 Mar 2010 22:00
Robert Haas wrote: > On Thu, Mar 11, 2010 at 4:19 PM, Bruce Momjian <bruce(a)momjian.us> wrote: > > ? ? ? ?$ sql -h localhost test > > ? ? ? ?psql: FATAL: ?password authentication failed for user "postgres" > > ? ? ? ?password retrieved from .pgpass > > I find this not quite explicit enough for my taste. Maybe something like this? > > the failing password was retrieved from .pgpass Uh, not sure. That doesn't match the style of many of our other messages. -- Bruce Momjian <bruce(a)momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |