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


Tue, 25 Aug 1998 19:18:46 +0100 (BST)
Keith Parks <emkxp01@mtcc.demon.co.uk>
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!!

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)

Thu, 27 Aug 1998 13:29:53 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] initdb problem