Re: index and sequence name length limit?

From: Jeff Davis <list-pgsql-general(at)empires(dot)org>
To: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: index and sequence name length limit?
Date: 2002-08-05 06:33:51
Message-ID: 200208042333.51541.list-pgsql-general@empires.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I believe that this question relates to a discussion on -hackers, in which
they are deciding how large to allow the names to be. It looks like the next
release will allow either 64 or 128 characters.

Eventually, I think there are plans to make it a true variable length type for
efficiency and flexibility. I don't think that it will make the next release,
however (7.3).

Regards,
Jeff Davis

On Sunday 04 August 2002 08:41 pm, Jean-Christian Imbeault wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2002-08-05 06:43:17 Re: saving a view with pg_dump
Previous Message Stuart robinson 2002-08-05 06:11:14 how to get the primary key of a freshly inserted row in a stored procedure