Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 3C8D447612B for ; Tue, 30 Apr 2002 14:37:53 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id CA82C475CE8 for ; Tue, 30 Apr 2002 14:32:58 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g3UIWvF21329; Tue, 30 Apr 2002 14:32:57 -0400 (EDT) To: Erik_Erkelens@yahoo.com, pgsql-bugs@postgresql.org Subject: Re: Bug #652: NAMEDATALEN limitations In-reply-to: <20020430181519.5E5D9475985@postgresql.org> References: <20020430181519.5E5D9475985@postgresql.org> Comments: In-reply-to pgsql-bugs@postgresql.org message dated "Tue, 30 Apr 2002 14:15:19 -0400" Date: Tue, 30 Apr 2002 14:32:57 -0400 Message-ID: <21326.1020191577@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200204/185 X-Sequence-Number: 3605 pgsql-bugs@postgresql.org writes: > If NAMEDATALEN is given values of 45,61 initdb -d will fail with the error "relation pg_proc does not exist'. Did you try to track down why? Although it's inefficient to declare NAMEDATALEN as not a multiple of 4 (because of alignment considerations --- the space will just be wasted as pad bytes, so you might as well use it), I don't offhand know why it wouldn't work. I don't *think* there is any assumption that it's a power of 2 ... but the well-tested cases are all powers of 2, so ... > I'd appreciate a comment in e.g. postgress_ext.h telling me e.g. that it should be a power of two, even or something like that. To do that, we'd need to know what the constraint actually is. Do you care enough to do the research to find out?