Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem - PostgreSQL Truncating Column Names to 63 Characters - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem - PostgreSQL Truncating Column Names to 63 Characters
Date
Msg-id 24862.1116003348@sss.pgh.pa.us
Whole thread Raw
In response to Problem - PostgreSQL Truncating Column Names to 63 Characters  (Darren Houston <darren.houston@gmail.com>)
List pgsql-general
Tree view 
Darren Houston <darren.houston@gmail.com> writes:
> PostgreSQL is truncating the column names down to 63 characters, and
> some of my names need to be a little larger than that. Is a 63 column
> name length a limit in PostgreSQL, or is there a
> setting/function/compile time option I can enact to overcome this
> problem?

See NAMEDATALEN ... the pghackers archives contain some traffic about
the performance penalty for increasing it ...

            regards, tom lane

pgsql-general by date:

Previous
From: Aly Dharshi
Date:
Subject: Re: [ANNOUNCE] SECURITY RELEASES: 7.2.8 - 7.3.10 - 7.4.8
Next
From: Alvaro Herrera
Date:
Subject: Re: Problem - PostgreSQL Truncating Column Names to 63 Characters