Re: [HACKERS] adding fields to pg_database

2006-04-11 Thread Jonah H. Harris
On 4/11/06, Tom Lane <[EMAIL PROTECTED]> wrote: > Good ways to answer this sort of question are: > > 1. Grep for references to some of the existing fields in the same catalog. > > 2. Look at the CVS diff for previous commits that added fields to the > same catalog. True, true. -- Jonah H. Harris,

Re: [HACKERS] adding fields to pg_database

2006-04-11 Thread Tom Lane
"Jonah H. Harris" <[EMAIL PROTECTED]> writes: > On 4/11/06, Markus Schiltknecht <[EMAIL PROTECTED]> wrote: >> I've only added the fields in include/catalog/pg_database.h. Do I need >> to fiddle other places? > Make sure you updated Natts_pg_database, the bootstrap DATA line, and > the stuff in src

Re: [HACKERS] adding fields to pg_database

2006-04-11 Thread Jonah H. Harris
On 4/11/06, Markus Schiltknecht <[EMAIL PROTECTED]> wrote: > dbcommands.c was the missing peace, thank you! No problemo :) -- Jonah H. Harris, Database Internals Architect EnterpriseDB Corporation 732.331.1324 ---(end of broadcast)--- TIP 6: explai

Re: [HACKERS] adding fields to pg_database

2006-04-11 Thread Markus Schiltknecht
On Tue, 2006-04-11 at 14:07 -0400, Jonah H. Harris wrote: > Make sure you updated Natts_pg_database, the bootstrap DATA line, and > the stuff in src/backend/commands/dbcommands.c. dbcommands.c was the missing peace, thank you! Markus ---(end of broadcast)---

Re: [HACKERS] adding fields to pg_database

2006-04-11 Thread Jonah H. Harris
On 4/11/06, Markus Schiltknecht <[EMAIL PROTECTED]> wrote: > I've only added the fields in include/catalog/pg_database.h. Do I need > to fiddle other places? Make sure you updated Natts_pg_database, the bootstrap DATA line, and the stuff in src/backend/commands/dbcommands.c. Other than that I don

[HACKERS] adding fields to pg_database

2006-04-11 Thread Markus Schiltknecht
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 enoug