Problems starting Template1...
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@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 -
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Mon, Oct 23, 2006 at 02:32:47PM -0400, luis garcia wrote:
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@Baco:~> /home/luis/pgsql/bin/initdb -D /home/luis/pgsql/data/
[...]
incorrect number of columns in row (expected 32, got 29)
^^^^^^^^^^^^^^^^^^^^^
[...]
I just added three more fields to pg_class structure (pg_class.h) just like
this:
Note that you are changing the core data structures of PostgreSQL. You
should change all the programs that work with them too :-)
More to the point: what are you trying to achieve?
Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFFQGUiBcgs9XrR2kYRAgOuAJ424LQIicJORfaQATng9xQzk9Fq0wCeKRW4
bUtdKg/bsHA3Mc1XZg10k3U=
=/EF7
-----END PGP SIGNATURE-----
Hi, we all ready found the problem. I was creating the pg_class structure
for 32 fields, but in the creation of Template1 I just inserted 29
initialization
values, so the problem was that.
Just like this:
Wrong CODE:
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_ ));
Right CODE:
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 f null 0 _null_ ));
If you see deep in there in the Wrong CODE there are just 29 values, but
in the Right CODE are 32, just as it should be.
Thanks anyway...
2006/10/26, tomas@tuxteam.de <tomas@tuxteam.de>:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1On Mon, Oct 23, 2006 at 02:32:47PM -0400, luis garcia wrote:
Hello, I'm from Venezuela, and I've been making some modifications
to Postgre's Catalog, but it seems to be a problem creating theTemplate1
Database.
When the creation of the database is starting this is what happens:
luis@Baco:~> /home/luis/pgsql/bin/initdb -D /home/luis/pgsql/data/
[...]
incorrect number of columns in row (expected 32, got 29)
^^^^^^^^^^^^^^^^^^^^^
[...]I just added three more fields to pg_class structure (pg_class.h) just
like
this:
Note that you are changing the core data structures of PostgreSQL. You
should change all the programs that work with them too :-)More to the point: what are you trying to achieve?
Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)iD8DBQFFQGUiBcgs9XrR2kYRAgOuAJ424LQIicJORfaQATng9xQzk9Fq0wCeKRW4
bUtdKg/bsHA3Mc1XZg10k3U=
=/EF7
-----END PGP SIGNATURE-----
--
Luis D. García M.
Telf: 0414-3482018
- FACYT - UC -
- Computación -