What was the exact version of PostgreSQL where the column name length changed from 31 to 63 characters?

On Tue, 2011-04-26 at 18:35 +0000, Dann Corbit wrote:

I need to know so that I can handle cases like:

Create table foolongcols(
nevermindthefurthermorejustpleadinselfdefense char(5),
nevermindthefurthermorejustpleadguilty char(5)
);

I assume that other object names (table name, function name, etc.) are similarly affected. Is that correct?

It was changed in this commit:

http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=46bb23ac016714065711cf2a780e080c7310d66e

which was first released in 7.3.0, as far as I can tell.

Regards,
Jeff Davis

On Tue, Apr 26, 2011 at 1:35 PM, Dann Corbit <DCorbit@connx.com> wrote:

I need to know so that I can handle cases like:

Create table foolongcols(
       nevermindthefurthermorejustpleadinselfdefense char(5),
       nevermindthefurthermorejustpleadguilty char(5)
);

I assume that other object names (table name, function name, etc.) are similarly affected.  Is that correct?

It looks like the 32->64 change went in 7.3. (see:
http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/postgres_ext.h)

merlin

-----Original Message-----
From: Jeff Davis [mailto:pgsql@j-davis.com]
Sent: Tuesday, April 26, 2011 11:44 AM
To: Dann Corbit
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] What was the exact version of PostgreSQL where
the column name length changed from 31 to 63 characters?

On Tue, 2011-04-26 at 18:35 +0000, Dann Corbit wrote:

I need to know so that I can handle cases like:

Create table foolongcols(
nevermindthefurthermorejustpleadinselfdefense char(5),
nevermindthefurthermorejustpleadguilty char(5)
);

I assume that other object names (table name, function name, etc.)

are similarly affected. Is that correct?

It was changed in this commit:

http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=46bb23
ac016714065711cf2a780e080c7310d66e

which was first released in 7.3.0, as far as I can tell.

Thanks (and also to Merlin Moncure) for finding this information.