Re: [HACKERS] initdb problem

Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)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