Postgres Pro
Downloads
Home   >   mailing lists

Re: index and sequence name length limit? - Mailing list pgsql-general

From Neil Conway
Subject Re: index and sequence name length limit?
Date
Msg-id 87fzxtlpgr.fsf@klamath.dyndns.org
Whole thread Raw
In response to index and sequence name length limit?  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
Tree view 
Jean-Christian Imbeault <jc@mega-bucks.co.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@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: saving a view with pg_dump
Next
From: "Sam Liddicott"
Date:
Subject: Re: \d very, very, very slow