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 -
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 |