Обсуждение: What was the exact version of PostgreSQL where the column name length changed from 31 to 63 characters?

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?

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

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

> -----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.