Re: Table name length (maximum identifier length)

"Mourad EL HADJ MIMOUNE" <mimoune@ensma.fr> writes:
> 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.

Did you actually recompile everything? (As in "gmake clean", "gmake all"
in the top-level directory?)  Did you remember to reinstall the modified
binaries ("gmake install")?

            regards, tom lane