Re: Table name length (maximum identifier length)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mourad EL HADJ MIMOUNE" <mimoune(at)ensma(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Table name length (maximum identifier length)
Date: 2002-06-24 15:21:01
Message-ID: 18332.1024932061@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Mourad EL HADJ MIMOUNE" <mimoune(at)ensma(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pablo Morales 2002-06-24 15:25:48 initdb
Previous Message Dave Page 2002-06-24 15:20:17 Re: foreign Key problem