Postgres Pro
Downloads
Home   >   mailing lists

Table name length (maximum identifier length) - Mailing list pgsql-general

From Mourad EL HADJ MIMOUNE
Subject Table name length (maximum identifier length)
Date
Msg-id 002f01c21b57$64489be0$71a337c1@ensma.fr
Whole thread Raw
In response to Re: SQL server application porting headache  (Curt Sampson <cjs@cynic.net>)
Responses Re: Table name length (maximum identifier length)  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Table name length (maximum identifier length)  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
Hi,
I want CREATE TABLES WHICH HAVE a name length more than 31.
I change NAMEDATALEN in src/include/postgres_ext.h from 32 to 100 and
recompile the source code. I init the database and create a test base but
the maximum identifier length is still  31.
Can someone explain me what I must do to change this.
Thanks.
Mourad.

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Added index ability for isbn-issn contrib example
Next
From: Stephan Szabo
Date:
Subject: Re: foreign Key problem