Re: Patch for str_numth() in PG 7.4

Andreas 'ads' Scherbaum <adsmail@wars-nicht.de> writes:

> I tracked the problem done to the function str_numth() in
> src/backend/utils/adt/formatting.c. The fix (attached) is easy: i
> stole the function code from the latest 8.0 version which looks fare
> more sane in handling the string pointers.

I think you attached the wrong patch.

> *** src/bin/psql/describe.c    2008-12-21 13:19:40.000000000 +0100
> --- src/bin/psql/describe.c.orig    2008-12-21 02:16:31.000000000 +0100
> ***************
> *** 464,476 ****
>                             "       d.datctype as \"%s\",\n",
>                             gettext_noop("Collation"),
>                             gettext_noop("Ctype"));
> !     if (pset.sversion >= 80100)
> !         appendPQExpBuffer(&buf,
> !                       "       pg_catalog.array_to_string(d.datacl, E'\\n') as \"%s\"",
> !                       gettext_noop("Access Privileges"));
> !     else
> !         appendPQExpBuffer(&buf,
> !                       "       pg_catalog.array_to_string(d.datacl, '\\n') as \"%s\"",
>                         gettext_noop("Access Privileges"));
>       if (verbose && pset.sversion >= 80200)
>           appendPQExpBuffer(&buf,
> --- 464,471 ----
>                             "       d.datctype as \"%s\",\n",
>                             gettext_noop("Collation"),
>                             gettext_noop("Ctype"));
> !     appendPQExpBuffer(&buf,
> !                       "       d.datacl as \"%s\"",
>                         gettext_noop("Access Privileges"));
>       if (verbose && pset.sversion >= 80200)
>           appendPQExpBuffer(&buf,

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services!