Re: [Proposal] Global temporary tables - Mailing list pgsql-hackers

Thanks, the "group by" is fixed

Yet another crash (on v58 patches), reproduced with:

psql -t -c "create global temp table t(b text) with(on_commit_delete_rows=true); create index idx_b on t (b); insert into t values('test'); alter table t alter b type varchar;"
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
connection to server was lost

with trace:

[New LWP 569199]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
Core was generated by `postgres: andrew postgres [local] ALTER TABLE                                 '.
Program terminated with signal SIGABRT, Aborted.
#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
50      ../sysdeps/unix/sysv/linux/raise.c: No such file or directory.
(gdb) bt
#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#1  0x00007f197493f859 in __GI_abort () at abort.c:79
#2  0x00005562b3306fb9 in ExceptionalCondition (conditionName=0x5562b34dd740 "reln->md_num_open_segs[forkNum] == 0", errorType=0x5562b34dd72c "FailedAssertion", fileName=0x5562b34dd727 "md.c", lineNumber=187) at assert.c:69
#3  0x00005562b3148f15 in mdcreate (reln=0x5562b41abdc0, forkNum=MAIN_FORKNUM, isRedo=false) at md.c:187
#4  0x00005562b314b73f in smgrcreate (reln=0x5562b41abdc0, forknum=MAIN_FORKNUM, isRedo=false) at smgr.c:335
#5  0x00005562b2d88b23 in RelationCreateStorage (rnode=..., relpersistence=103 'g', rel=0x7f196b597270) at storage.c:154
#6  0x00005562b2d5a408 in index_build (heapRelation=0x7f196b58dc40, indexRelation=0x7f196b597270, indexInfo=0x5562b4167d60, isreindex=true, parallel=false) at index.c:3038
#7  0x00005562b2d533c1 in RelationTruncateIndexes (heapRelation=0x7f196b58dc40, lockmode=1) at heap.c:3354
#8  0x00005562b2d5360b in heap_truncate_one_rel (rel=0x7f196b58dc40) at heap.c:3452
#9  0x00005562b2d53544 in heap_truncate (relids=0x5562b4167c58, is_global_temp=true) at heap.c:3410
#10 0x00005562b2ea09fc in PreCommit_on_commit_actions () at tablecmds.c:16495
#11 0x00005562b2d0d4ee in CommitTransaction () at xact.c:2140
#12 0x00005562b2d0e320 in CommitTransactionCommand () at xact.c:2979
#13 0x00005562b3151b7e in finish_xact_command () at postgres.c:2721
#14 0x00005562b314f340 in exec_simple_query (query_string=0x5562b40c2170 "create global temp table t(b text) with(on_commit_delete_rows=true); create index idx_b on t (b); insert into t values('test'); alter table t alter b type varchar;") at postgres.c:1239
#15 0x00005562b3153f0a in PostgresMain (dbname=0x5562b40ed6e8 "postgres", username=0x5562b40ed6c8 "andrew") at postgres.c:4497
#16 0x00005562b307df6e in BackendRun (port=0x5562b40e4500) at postmaster.c:4560
#17 0x00005562b307d853 in BackendStartup (port=0x5562b40e4500) at postmaster.c:4288
#18 0x00005562b3079a1d in ServerLoop () at postmaster.c:1801
#19 0x00005562b30791b6 in PostmasterMain (argc=3, argv=0x5562b40bc5b0) at postmaster.c:1473
#20 0x00005562b2f6d98e in main (argc=3, argv=0x5562b40bc5b0) at main.c:198