Re: [HACKERS] Indixing problems...

>> Only remaining problem seems somewhat related to view. Still the
>> select_views test and "select * from pg_user" produces core dumps.
>                         ^^^^^^^^^^^^^^^^^^^^^
>After some users were added or just after initdb ?

Just after initdb. Here is a backtrace info.

POSTGRES backend interactive interface
$Revision: 1.89 $ $Date: 1998/09/01 04:32:13 $
> select * from pg_user;
blank
     1: usename    (typeid = 19, len = 32, typmod = -1, byval = f)
     2: usesysid    (typeid = 23, len = 4, typmod = -1, byval = t)
     3: usecreatedb    (typeid = 16, len = 1, typmod = -1, byval = t)
     4: usetrace    (typeid = 16, len = 1, typmod = -1, byval = t)
     5: usesuper    (typeid = 16, len = 1, typmod = -1, byval = t)
     6: usecatupd    (typeid = 16, len = 1, typmod = -1, byval = t)
     7: passwd    (typeid = 25, len = -1, typmod = -1, byval = f)
     8: valuntil    (typeid = 702, len = 4, typmod = -1, byval = t)
    ----
     1: usename = "t-ishii"    (typeid = 19, len = 32, typmod = -1, byval = f)
     2: usesysid = "1739"    (typeid = 23, len = 4, typmod = -1, byval = t)
     3: usecreatedb = "t"    (typeid = 16, len = 1, typmod = -1, byval = t)
     4: usetrace = "t"    (typeid = 16, len = 1, typmod = -1, byval = t)
     5: usesuper = "t"    (typeid = 16, len = 1, typmod = -1, byval = t)
     6: usecatupd = "t"    (typeid = 16, len = 1, typmod = -1, byval = t)
     7: passwd = "********"    (typeid = 25, len = -1, typmod = -1, byval = f)
     8: valuntil = "Sat Jan 31 15:00:00 2037 JST"    (typeid = 702, len = 4, typmod = -1, byval = t)
    ----

Program received signal SIGSEGV, Segmentation fault.
0x2ae3b32c in chunk_free ()
(gdb) where
#0  0x2ae3b32c in chunk_free ()
#1  0x2ae3b1e8 in cfree ()
#2  0x18f2f10 in AllocSetFree (set=0x2aeca454, pointer=0x1a093c0 "")
    at aset.c:222
#3  0x18f2e14 in AllocSetReset (set=0x19f8700) at aset.c:132
#4  0x18f436c in EndPortalAllocMode () at portalmem.c:920
#5  0x1836a44 in AtCommit_Memory () at xact.c:696
#6  0x1836c60 in CommitTransaction () at xact.c:911
#7  0x1836ec8 in CommitTransactionCommand () at xact.c:1137
#8  0x18bfd70 in PostgresMain (argc=2, argv=0x1920000, real_argc=2,
    real_argv=0x7ffff8b4) at postgres.c:1645
#9  0x186ca08 in main (argc=0, argv=0x19f8700) at main.c:103
#10 0x1818228 in _start ()
--
Tatsuo Ishii
t-ishii@sra.co.jp