Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] initdb problem

From: Keith Parks <emkxp01(at)mtcc(dot)demon(dot)co(dot)uk>
To: meskes(at)online-club(dot)de, maillist(at)candle(dot)pha(dot)pa(dot)us
Cc: hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] initdb problem
Date: 1998-08-25 18:18:46
Message-ID: 199808251818.TAA15065@mtcc.demon.co.uk (view raw or flat)
Thread:
Lists: pgsql-hackers
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


Responses

pgsql-hackers by date

Next:From: Nick BastinDate: 1998-08-25 19:50:43
Subject: Re: [HACKERS] Open 6.4 items
Previous:From: Bruce MomjianDate: 1998-08-25 17:55:07
Subject: Re: [HACKERS] Open 6.4 items

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group