Re: [HACKERS] initdb problem - Mailing list pgsql-hackers

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