Indexscan failed assert caused by using index without lock

Following example can reproduce the problem: ``` create table d(a int); create index di on d(a); set enable_seqscan=off; set enable_bitmapscan to off; prepare p as delete from d where a=3; execute p; execute p; ``` The reason is that: ExecInitIndexScan will not lock index because it thinks

Re: no library dependency in Makefile?

ways to do that: first, add a new PG_STLIBS variable, user need to add static libs to it; second, we generate static lib dependency automatically from PG_LIBS variable. Which one is better? Thanks 2017-11-20 17:00 GMT+08:00 高增琦 <pgf...@gmail.com>: > The attached patch use normal d

Re: How is the PostgreSQL debuginfo file generated

A little trick： 1. configure with —enable-debug, run “make install”, use this build result as debuginfo 2. then run “make install-strip”, use this result as release However the it is not the regular debuginfo, you still can call gdb with it. Additionally, you can dump the real debuginfo from it

Re: no library dependency in Makefile?

2017-11-20 2:25 GMT+08:00 Tom Lane : > =?UTF-8?B?6auY5aKe55Cm?= writes: > > I very much look forward to hearing everyone's views on this issue. > > If the solution mentioned before is ok, I will start to complete it. > > Please don't top-post, it makes the

Patch to add dependency between client executes and static libraries

Hi, all The attached patch trying to add dependency between client executes and static libraries. As described in message:

Re: no library dependency in Makefile?

I very much look forward to hearing everyone's views on this issue. If the solution mentioned before is ok, I will start to complete it. thanks 高增琦 <pgf...@gmail.com>于2017年11月16日 周四20:51写道： > LDFLAGS in the example changed to: > > ''' > override LDFLAGS := $(call expa

Re: no library dependency in Makefile?

LDFLAGS in the example changed to: ''' override LDFLAGS := $(call expand_stlibs,$(STLIBS)) $(libpq_pgport) $(LDFLAGS) ''' 2017-11-16 20:50 GMT+08:00 高增琦 <pgf...@gmail.com>: > Is this a problem or not? > > > A simple fix: > 1. add a STLIBS variable in Makefiles as normal

Re: no library dependency in Makefile?

-libpq submake-libpgport submake-libpgfeutils $(CC) $(CFLAGS) $(OBJS) $(LDFLAGS) $(LDFLAGS_EX) $(LIBS) -o $@$(X) ''' 2017-11-15 16:10 GMT+08:00 高增琦 <pgf...@gmail.com>: > Hi, > > Recently, I found 'psql' is not rebuilt automatically after > editing 'fe_utils/psqlscan.l'. > >

no library dependency in Makefile?

Hi, Recently, I found 'psql' is not rebuilt automatically after editing 'fe_utils/psqlscan.l'. The detail is: 'psqlscan.l' is part of 'libpgfeutils.a' which will be built into 'psql' statically. But there is no dependency rule between them. It's OK for 'libpq' since 'libpq' is a dynamic