X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CA52311F68FF for ; Tue, 11 Apr 2006 14:54:38 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.12 X-Spam-Level: X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id TuVGKSrbJxKO for ; Tue, 11 Apr 2006 14:54:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from bugaboo.mu (213-146-165-140.kunde.vdserver.de [213.146.165.140]) by postgresql.org (Postfix) with ESMTP id 8BF2511F68C7 for ; Tue, 11 Apr 2006 14:54:32 -0300 (ADT) Received: from [192.168.77.2] (p54BE4CF8.dip.t-dialin.net [::ffff:84.190.76.248]) (AUTH: CRAM-MD5 markus@bluegap.ch) by bugaboo.mu with esmtp; Tue, 11 Apr 2006 19:54:30 +0200 id 00252890.443BED56.00000F51 Subject: adding fields to pg_database From: Markus Schiltknecht To: pgsql-hackers@postgresql.org Date: Tue, 11 Apr 2006 19:54:34 +0200 Message-Id: <1144778074.6682.8.camel@localhost.localdomain> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Mailer: Evolution 2.6.0 X-Archive-Number: 200604/371 X-Sequence-Number: 82094 Hi, I'm trying to add fields to pg_database in the system catalog. As long as I add fixed-size fields before the VAR LENGTH ones, that's all fine. But adding a VAR LENGTH (text) field initdb fails at: copying template1 to template0. The child process 'postgres' fails with signal 11. Strange enough I suspect the segfault to occure at program termination (?). That is just after the following initdb commands have been executed: ... "REVOKE CREATE,TEMPORARY ON DATABASE template1 FROM public;\n", "REVOKE CREATE,TEMPORARY ON DATABASE template0 FROM public;\n", /* * Finally vacuum to clean up dead rows in pg_database */ "VACUUM FULL pg_database;\n", I've only added the fields in include/catalog/pg_database.h. Do I need to fiddle other places? Regards Markus