Re: NAMEDATALEN - Mailing list pgsql-general

From Tom Lane
Subject Re: NAMEDATALEN
Date
Msg-id 24865.989528689@sss.pgh.pa.us
Whole thread Raw
In response to NAMEDATALEN  ("Thomas F. O'Connell" <tfo@monsterlabs.com>)
List pgsql-general
"Thomas F. O'Connell" <tfo@monsterlabs.com> writes:
> in src/include/postgres_ext.h, it mentions that "... databases with
> different NAMEDATALEN's cannot interoperate!", and i was wondering if
> included when altering NAMEDATALEN for a database that already has data
> even if performing a pg_dump on it.

Dump, recompile, initdb, reload should work.  Be aware however that
NAMEDATALEN is visible to clients (in particular, in libpq's
datastructure for Notify results), so you may have binary-compatibility
problems if you neglect to recompile your clients too.  I suspect that
is what the comment is really referring to.

            regards, tom lane

pgsql-general by date:

Previous
From: Zak McGregor
Date:
Subject: Re: formatting a date
Next
From: Tom Lane
Date:
Subject: Re: Re: Query not using index