index and sequence name length limit?

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: index and sequence name length limit?
Date: 2002-08-05 03:41:34
Message-ID: 3D4DF3EE.7070807@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What is the limit on the length of a index or sequence's name?

I have some table with long names and I find it confusing when pgsql
truncates the table name when creating indexes or sequences (for serials).

Why does such a limit exist? I would think that since there are
virtually no limits on the size of data that a table or column can hold
there should be no limit on the length of names assigned to
tables/sequences/indexes/etc ... or if that a limit would be rather long
(say 256 characters?).

Jc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Christian Imbeault 2002-08-05 04:08:43 COPY: SJIS file into EUC_JP DB: how?
Previous Message Steve Lane 2002-08-05 02:51:45 Re: reloading really big tables