Re: Require Assistance Solving Problem - erroneous pg_hba.conf

Never had them that I can tell - created a new .conf file using vi so I know
it was clean as I was testing. Uninstall/reinstall RPMs worked - sort of.
Now I'm getting pgadmin-II to blow up saying:

2003-04-17 12:27:17 - Error in pgAdmin
II:frmConnect.cmdConnect_Click: -2147417848 - Automation error
The object invoked has disconnected from its clients.

and my php-pgsql is showing:

pg_exec() query failed: ERROR: Bad date external representation

(but this may be a version out of sync as I just installed the php-pgsql
DSO)

...so all still isn't well in dodge...

I can run psql, connect to the scheduler database, do a SELECT, etc.

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Greg Kelley" <gkelley(at)britannicaviation(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>; "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>;
"Joe Conway" <mail(at)joeconway(dot)com>
Sent: 17 April, 2003 12:53 PM
Subject: Re: [ADMIN] Require Assistance Solving Problem - erroneous
pg_hba.conf

"Greg Kelley" <gkelley(at)britannicaviation(dot)com> writes:
> A RedHat Upgrade Saturday from 8.0 to 9.0 just did a 'minor' version
> upgrade from 7.3.1 to 7.3.2.
> [ and broke his pg_hba.conf ]

Ah-hah, I now know where the behavioral change came from: the Red Hat
RPMs contain this patch:

--- postgresql-7.3.2/src/backend/libpq/hba.c.sopwith 2003-01-09
09:09:01.000000000 -0500
+++ postgresql-7.3.2/src/backend/libpq/hba.c 2003-01-09
09:09:09.000000000 -0500
@@ -72,11 +72,13 @@
* Some standard C libraries, including GNU, have an isblank() function.
* Others, including Solaris, do not. So we have our own.
*/
+#ifndef isblank
static bool
isblank(const char c)
{
return c == ' ' || c == '\t' || c == '\r';
}
+#endif

/*

which on RHL 9 causes the system definition of isblank() to be
substituted for Postgres'. That means \r is no longer treated as
whitespace, as it was in prior versions.

There is a fix in our CVS tree that prevents this problem and restores
the old treatment of \r, but for now you gotta get rid of the Windows-
style newlines.

regards, tom lane