Thread: Problems starting Template1...

Hello, I'm from Venezuela, and I've been making some modifications <br />to Postgre's Catalog, but it seems to be a
problemcreating the Template1 <br />Database. <br /><br />When the creation of the database is starting this is what
happens:<br /><br />luis@Baco:~> /home/luis/pgsql/bin/initdb -D /home/luis/pgsql/data/<br /><span style="font-style:
italic;"><br/>The files belonging to this database system will be owned by user "luis".<br />This user must also own
theserver process. <br /><br />The database cluster will be initialized with locale es_ES.UTF-8.<br />The default
databaseencoding has accordingly been set to UTF8.<br /><br />fixing permissions on existing directory
/home/luis/pgsql/data... ok<br /> creating directory /home/luis/pgsql/data/global ... ok<br />creating directory
/home/luis/pgsql/data/pg_xlog... ok<br />creating directory /home/luis/pgsql/data/pg_xlog/archive_status ... ok<br
/>creatingdirectory /home/luis/pgsql/data/pg_clog ... ok <br />creating directory /home/luis/pgsql/data/pg_subtrans ...
ok<br/>creating directory /home/luis/pgsql/data/pg_twophase ... ok<br />creating directory
/home/luis/pgsql/data/pg_multixact/members... ok<br />creating directory /home/luis/pgsql/data/pg_multixact/offsets ...
ok<br />creating directory /home/luis/pgsql/data/base ... ok<br />creating directory /home/luis/pgsql/data/base/1 ...
ok<br/>creating directory /home/luis/pgsql/data/pg_tblspc ... ok<br />selecting default max_connections ... 100<br />
selectingdefault shared_buffers ... 1000<br />creating configuration files ... </span>ok<br style="font-style: italic;"
/><spanstyle="font-style: italic;">creating template1 database in /home/</span>luis<span style="font-style: italic;">
/</span>pgsql<spanstyle="font-style: italic;">/data/base/1 ... FATAL:  incorrect number of columns in row (expected 32,
got29)</span><br style="font-style: italic;" /><span style="font-style: italic;">child process exited with exit code 1
<br/>initdb: removing contents of data directory "/home/luis/pgsql/data"<br style="font-style: italic;" /></span><span
style="font-style:italic;"></span><br /><br />I just added three more fields to pg_class structure (pg_class.h) just
likethis: <br /><br />.<br />.<br />bool<span style="font-style: italic;">             </span>relhasfrequency<span
style="font-style:italic;">;    /* has time frequency */</span><br style="font-style: italic;" />NameData<span
style="font-style:italic;">     </span>relfrequencytype<span style="font-style: italic;">;  /* table time frequency
type(REAL_TIME, HISTORIC)*/</span><br style="font-style: italic;" />NameData<span style="font-style: italic;">   
</span>relfrequency<spanstyle="font-style: italic;"> ;         /* </span><span style="font-style: italic;">class time
frequencyvalue*/</span><br style="font-style: italic;" /><span style="font-style: italic;">.</span><br />.<br />.<br
/>.<br/><span style="font-style: italic;">#define Natts_pg_class_fixed                 31 </span><br style="font-style:
italic;"/><span style="font-style: italic;">#define Natts_pg_class                          32</span><br
style="font-style:italic;" /><span style="font-style: italic;">#define Anum_pg_class_relname            1 </span><br
style="font-style:italic;" /><span style="font-style: italic;">#define Anum_pg_class_relnamespace  2</span><br
style="font-style:italic;" /><span style="font-style: italic;">.</span><br />.<br />.<br /><span style="font-style:
italic;">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_ ));</span><br style="font-style: italic;" />.<br />.<br />.<br style="font-style: italic;" /><br />-pg_class-
hasoriginally 25 fields, and one of my friends has added four more <br />with no problems, but it seems to be a problem
withthe changes I've made, and<br />we don't know witch is it...<br /><br clear="all" /><br />I also made the next
changesto pg_attribute.h:<br />.<br />.<br />.<br />{ 1259, {"relhasfrequency"},16, -1,    1, 29, 0, -1, -1, true, 'p',
'c',true, false, false, true, 0 }, \ <br />{ 1259, {"relfrequencytype"},       19, -1, NAMEDATALEN, 30, 0, -1, -1,
false,'p', 'i', true, false, false, true, 0 }, \<br />{ 1259, {"relfrequency"},    19, -1, NAMEDATALEN, 31, 0, -1, -1,
false,'p', 'i', true, false, false, true, 0 }, \ <br />{ 1259, {"relacl"},         1034, -1, -1, 32, 1, -1, -1, false,
'x','i', false, false, false, true, 0 }<br />.<br />.<br />.<br />DATA(insert ( 1259,relhasfrequency    16 -1 1 29  0
-1-1 t p c t f f t 0));<br />DATA(insert ( 1259,relfrequencytype        19 -1 NAMEDATALEN    30 0 -1 -1 f p i t f f t
0));<br />DATA(insert ( 1259,relfrequency            19 -1 NAMEDATALEN    31 0 -1 -1 f p i t f f t 0));<br
/>DATA(insert( 1259 relacl          1034 -1 -1 32 1 -1 -1 f x i f f f t 0));<br />.<br />.<br />.<br /><br />If anyone
couldhelp me on this I would be very grateful, because this is the final <br />project of my Career... THANKS<br /><br
/>--<br />Luis D. García M.<br />Telf: 0414-3482018<br /><br />- FACYT - UC -<br />- 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...




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

- FACYT - UC -
- Computación -