Обсуждение: 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)