Thread: What was the exact version of PostgreSQL where the column name length changed from 31 to 63 characters?
What was the exact version of PostgreSQL where the column name length changed from 31 to 63 characters?
From
Dann Corbit
Date:
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?
Re: What was the exact version of PostgreSQL where the column name length changed from 31 to 63 characters?
From
Merlin Moncure
Date:
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
Re: What was the exact version of PostgreSQL where the column name length changed from 31 to 63 characters?
From
Jeff Davis
Date:
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
Re: What was the exact version of PostgreSQL where the column name length changed from 31 to 63 characters?
From
Dann Corbit
Date:
> -----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.