Re: index and sequence name length limit?

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: index and sequence name length limit?
Date: 2002-08-05 07:44:20
Message-ID: 87fzxtlpgr.fsf@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> writes:
> What is the limit on the length of a index or sequence's name?

31 by default, but you can increase that by changing the value of
NAMEDATALEN in src/include/pg_config.h, re-compiling, and re-running
initdb.

Cheers,

Neil

--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Liddicott 2002-08-05 07:47:41 Re: \d very, very, very slow
Previous Message Marko Asplund 2002-08-05 07:31:42 concept question: PostgreSQL vs. Oracle database