Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Table name length (maximum identifier length)
Date
Msg-id 18332.1024932061@sss.pgh.pa.us
Whole thread Raw
In response to Table name length (maximum identifier length)  ("Mourad EL HADJ MIMOUNE" <mimoune@ensma.fr>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: "Jeff MacDonald"
Date:
Subject: functions for date parsing.
Next
From: Justin Clift
Date:
Subject: PostgreSQL now part of the Lindows "Click-n-Run" Warehouse