Re: Table name length (maximum identifier length)

Mourad EL HADJ MIMOUNE wrote:
> 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.

That is very strange.  It should have worked and has worked for others
in the past.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026