Re: Table name length (maximum identifier length)

Hi Mourad,

I saw your message on the postgres group. I'm not terribly
familiar with postgres, but my experience with other
software packages is that sometimes I find myself running a
different executable than the one I just built. I'm
assuming your working on a unix OS? (I don't know if this is
a good assumption).

One thing you can do is check "which psql" and "which
initdb" to see which version of postgres executables are
being found in your path. You can even "ls -la `which
psql`" to see the date on the file. Is this the copy you
recently built? Echo $PATH to see if there are other
versions in your path. On some flavors of unix you can type
"where psql" or "where postmaster" to list all locations of
the executable in your path. Modify your PATH or move older
versions to a subdirectory to take them out of your path if
you find out you're running a version that's not the new
version.

And if this advice doesn't help, delete this message
quickly!

I hope this helps.

Sarah
smarie(at)ekno(dot)com

Mourad EL HADJ MIMOUNE wrote:
>
> Hi,
>
> Thanks.
>
> I tried what you said ("gmake clean", "gmake all" and then "gmake install")
> without success.
>
> If you have more precision to do these please inform me?!
>
> Best regards,
>
> Mourad.
>
> > "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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html