Re: Length of sql cols in postgresql

In 7.3, due out in a few months, the length will be 64.  You can
increase the length by modifying NAMEDATALEN in include/pg_config.h.in,
running configure again, compiling, and initdb.  You can't change it
without a dump/reload of the data.

---------------------------------------------------------------------------

Th Templ wrote:
> Hello,
>
> I have problem with the cols of table. Postgresql truncates some of them
> which are longer than 30 characters.
> And when I execute a request in psql, I have the following message:
>
> psql:/applis/jgenea/test.sql:37: NOTICE:  identifier
> "commune_nom_equivalent_naissance"
> will be truncated to "commune_nom_equivalent_naissanc"
>
> Is it possible to increase the maximum length?
> Thianks for your help
> Thierry
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073