From: Rudi Starcevic <rudi@oasis.net.au>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: Sequence name length
Date: Wed, 17 Jul 2002 13:51:13 +1000
Message-ID: <3D34E9B1.6000308@oasis.net.au> (raw)
References: <3D34D8B3.8060102@oasis.net.au>
<10750.1026877256@sss.pgh.pa.us>
Hi Tom,
Here is the output from 'select version()'
PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.95.2
Cheers
Rudi.
Tom Lane wrote:
>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: rudi@oasis.net.au, tgl@sss.pgh.pa.us
Subject: Re: Sequence name length
In-Reply-To: <3D34E9B1.6000308@oasis.net.au>
* 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