From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rudi Starcevic <rudi@oasis.net.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: Sequence name length
Date: Tue, 16 Jul 2002 23:40:56 -0400
Message-ID: <10750.1026877256@sss.pgh.pa.us> (raw)
In-Reply-To: <3D34D8B3.8060102@oasis.net.au>
References: <3D34D8B3.8060102@oasis.net.au>
Rudi Starcevic <rudi@oasis.net.au> writes:
> Just a quick one on the length of the name of a sequence.
> ...
> However the sequence created is named :
> eselect_maincategory_maincat_id ( the '_seq' is lopped off )
What version are you running? Anything recent will keep the '_seq'
and lop elsewhere.
> This looke like a max of 31 characters.
Yeah, the default NAMEDATALEN is 32, allowing for 31 chars plus a
terminating null. You can build a private version with larger
NAMEDATALEN, and there are recurring discussions about increasing
the default length.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, rudi@oasis.net.au
Subject: Re: Sequence name length
In-Reply-To: <10750.1026877256@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox