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(at)sra(dot)co(dot)jp