Problems starting Template1...

From: "luis garcia" <ldgarc(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Problems starting Template1...
Date: 2006-10-23 18:32:47
Message-ID: 3de424340610231132y5de0b4efj79a47528d33854f1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello, I'm from Venezuela, and I've been making some modifications
to Postgre's Catalog, but it seems to be a problem creating the Template1
Database.

When the creation of the database is starting this is what happens:

luis(at)Baco:~> /home/luis/pgsql/bin/initdb -D /home/luis/pgsql/data/

The files belonging to this database system will be owned by user "luis".
This user must also own the server process.

The database cluster will be initialized with locale es_ES.UTF-8.
The default database encoding has accordingly been set to UTF8.

fixing permissions on existing directory /home/luis/pgsql/data ... ok
creating directory /home/luis/pgsql/data/global ... ok
creating directory /home/luis/pgsql/data/pg_xlog ... ok
creating directory /home/luis/pgsql/data/pg_xlog/archive_status ... ok
creating directory /home/luis/pgsql/data/pg_clog ... ok
creating directory /home/luis/pgsql/data/pg_subtrans ... ok
creating directory /home/luis/pgsql/data/pg_twophase ... ok
creating directory /home/luis/pgsql/data/pg_multixact/members ... ok
creating directory /home/luis/pgsql/data/pg_multixact/offsets ... ok
creating directory /home/luis/pgsql/data/base ... ok
creating directory /home/luis/pgsql/data/base/1 ... ok
creating directory /home/luis/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 1000
creating configuration files ... ok
creating template1 database in /home/luis/pgsql/data/base/1 ... FATAL:
incorrect number of columns in row (expected 32, got 29)
child process exited with exit code 1
initdb: removing contents of data directory "/home/luis/pgsql/data"

I just added three more fields to pg_class structure (pg_class.h) just like
this:

.
.
bool relhasfrequency; /* has time frequency */
NameData relfrequencytype; /* table time frequency type (REAL_TIME,
HISTORIC)*/
NameData relfrequency; /* class time frequency value*/
.
.
.
.
#define Natts_pg_class_fixed 31
#define Natts_pg_class 32
#define Anum_pg_class_relname 1
#define Anum_pg_class_relnamespace 2
.
.
.
DATA(insert OID = 1259 ( pg_class PGNSP 83 PGUID 0 1259 0 0 0 0 0 f
f r 32 0 0 0 0 0 t f f f f null 0 f _null_ ));
.
.
.

-pg_class- has originally 25 fields, and one of my friends has added four
more
with no problems, but it seems to be a problem with the changes I've made,
and
we don't know witch is it...

I also made the next changes to pg_attribute.h:
.
.
.
{ 1259, {"relhasfrequency"},16, -1, 1, 29, 0, -1, -1, true, 'p', 'c',
true, false, false, true, 0 }, \
{ 1259, {"relfrequencytype"}, 19, -1, NAMEDATALEN, 30, 0, -1, -1,
false, 'p', 'i', true, false, false, true, 0 }, \
{ 1259, {"relfrequency"}, 19, -1, NAMEDATALEN, 31, 0, -1, -1, false, 'p',
'i', true, false, false, true, 0 }, \
{ 1259, {"relacl"}, 1034, -1, -1, 32, 1, -1, -1, false, 'x', 'i',
false, false, false, true, 0 }
.
.
.
DATA(insert ( 1259,relhasfrequency 16 -1 1 29 0 -1 -1 t p c t f f t 0));
DATA(insert ( 1259,relfrequencytype 19 -1 NAMEDATALEN 30 0 -1 -1 f
p i t f f t 0));
DATA(insert ( 1259,relfrequency 19 -1 NAMEDATALEN 31 0 -1 -1 f
p i t f f t 0));
DATA(insert ( 1259 relacl 1034 -1 -1 32 1 -1 -1 f x i f f f t 0));
.
.
.

If anyone could help me on this I would be very grateful, because this is
the final
project of my Career... THANKS

--
Luis D. García M.
Telf: 0414-3482018

- FACYT - UC -
- Computación -

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2006-10-23 18:36:28 Re: [PATCHES] smartvacuum() instead of autovacuum
Previous Message Dawid Kuroczko 2006-10-23 17:54:47 Re: New CRC algorithm: Slicing by 8