Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 71A74475CD3 for ; Tue, 16 Jul 2002 23:41:06 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g6H3euAl010751; Tue, 16 Jul 2002 23:40:56 -0400 (EDT) To: Rudi Starcevic Cc: pgsql-sql@postgresql.org Subject: Re: Sequence name length In-reply-to: <3D34D8B3.8060102@oasis.net.au> References: <3D34D8B3.8060102@oasis.net.au> Comments: In-reply-to Rudi Starcevic message dated "Wed, 17 Jul 2002 12:38:43 +1000" Date: Tue, 16 Jul 2002 23:40:56 -0400 Message-ID: <10750.1026877256@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200207/253 X-Sequence-Number: 8631 Rudi Starcevic 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