Rudi Starcevic <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly