Thread: Re: [HACKERS] initdb problem
Bruce Momjian <maillist@candle.pha.pa.us> > > > On Mon, Aug 24, 1998 at 03:18:28PM -0400, Bruce Momjian wrote: > > > Would someone check a running 6.3.2 system and let me know if there are > > > any blank attalign values? It think you will find that there are. The > > > current patch fixes that. > > > > echo "select * from pg_attribute where attalign != 'i' and attalign != > > 'c'and attalign != 'd' and attalign!='s';"|psql template1 > > Yikes. Good thing that is fixed now. > Another interesting thing? (appologies for the width) I would half expected attalign to be 'd' for all these. I'm not sure how the values get there though!! Keith. template1=> select * from pg_attribute where attlen = 32; attrelid|attname |atttypid|attdisbursion|attlen|attnum|attnelems|attcacheoff|atttypmod|attbyval|a ttisset|attalign|attnotnull|atthasdef --------+-----------+--------+-------------+------+------+---------+-----------+ ---------+--------+--------+--------+----------+--------- 1247|typname | 19| 0| 32| 1| 0| -1| -1|f |f |i |f |f 1262|datname | 19| 0| 32| 1| 0| -1| -1|f |f |i |f |f 1255|proname | 19| 0| 32| 1| 0| -1| -1|f |f |i |f |f 1255|proargtypes| 30| 0| 32| 10| 0| -1| -1|f |f |i |f |f 1260|usename | 19| 0| 32| 1| 0| -1| -1|f |f |i |f |f 1261|groname | 19| 0| 32| 1| 0| -1| -1|f |f |i |f |f 1249|attname | 19| 0| 32| 2| 0| -1| -1|f |f |i |f |f 1259|relname | 19| 0| 32| 1| 0| -1| -1|f |f |i |f |f 1216|rcname | 19| 0| 32| 2| 0| -1| -1|f |f |i |f |f 1219|tgname | 19| 0| 32| 2| 0| -1| -1|f |f |i |f |f 16548|indclass | 30| 0| 32| 5| 0| -1| -1|f |f |i |f |f 16590|oprname | 19| 0| 32| 1| 0| -1| -1|f |f |d |f |f 16614|opcname | 19| 0| 32| 1| 0| -1| -1|f |f |d |f |f 16624|amname | 19| 0| 32| 1| 0| -1| -1|f |f |d |f |f 16869|lanname | 19| 0| 32| 1| 0| -1| -1|f |f |d |f |f 16946|aggname | 19| 0| 32| 1| 0| -1| -1|f |f |d |f |f 17013|inhproname | 19| 0| 32| 1| 0| -1| -1|f |f |d |f |f 17025|rulename | 19| 0| 32| 1| 0| -1| -1|f |f |d |f |f 17040|relname | 19| 0| 32| 1| 0| -1| -1|f |f |d |f |f 17061|attname | 19| 0| 32| 2| 0| -1| -1|f |f |i |f |f 17073|proname | 19| 0| 32| 1| 0| -1| -1|f |f |i |f |f 17073|proargtypes| 30| 0| 32| 3| 0| -1| -1|f |f |i |f |f 17082|typname | 19| 0| 32| 1| 0| -1| -1|f |f |i |f |f 17088|relname | 19| 0| 32| 1| 0| -1| -1|f |f |i |f |f 17184|usename | 19| 0| 32| 1| 0| -1| -1|f |f |d |f |f 17248|rulename | 19| 0| 32| 1| 0| -1| -1|f |f |d |f |f 17312|viewname | 19| 0| 32| 1| 0| -1| -1|f |f |d |f |f
> Bruce Momjian <maillist@candle.pha.pa.us> > > > > > > On Mon, Aug 24, 1998 at 03:18:28PM -0400, Bruce Momjian wrote: > > > > Would someone check a running 6.3.2 system and let me know if there are > > > > any blank attalign values? It think you will find that there are. The > > > > current patch fixes that. > > > > > > echo "select * from pg_attribute where attalign != 'i' and attalign != > > > 'c'and attalign != 'd' and attalign!='s';"|psql template1 > > > > Yikes. Good thing that is fixed now. > > > > Another interesting thing? > > (appologies for the width) > > I would half expected attalign to be 'd' for all these. > > I'm not sure how the values get there though!! Can you research what the proper value should be. We have char/varchar set to 'i', but others set to 'd'. What should be the proper value. Is 'd' and 'i' alignment the same on our supported platforms. Does a char field of length 32 align on int, but a double align on double differently. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)