Re: Problem - PostgreSQL Truncating Column Names to 63 Characters

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Darren Houston <darren(dot)houston(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem - PostgreSQL Truncating Column Names to 63 Characters
Date: 2005-05-13 16:55:48
Message-ID: 24862.1116003348@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Darren Houston <darren(dot)houston(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2005-05-13 16:57:34 Re: Problem - PostgreSQL Truncating Column Names to 63 Characters
Previous Message Aly Dharshi 2005-05-13 16:49:00 Re: [ANNOUNCE] SECURITY RELEASES: 7.2.8 - 7.3.10 - 7.4.8