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
InitPl
At the end of SetupLockInTable(), there is a check for the "lock already
held" error.
Because the nRequested and requested[lockmode] value of a lock is bumped
before "lock already held" error, and there is no way to reduce them later
for
this situation, then it will keep the inconsistency in lock s
The attached patch attempts to fix this.
高增琦 于2024年9月11日周三 14:30写道：
> At the end of SetupLockInTable(), there is a check for the "lock already
> held" error.
> Because the nRequested and requested[lockmode] value of a lock is bumped
> before "lock already held&quo
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 library.
rerequisite
psql: $(OBJS) $(STLIBS) | submake-libpq submake-libpgport
submake-libpgfeutils
$(CC) $(CFLAGS) $(OBJS) $(LDFLAGS) $(LDFLAGS_EX) $(LIBS) -o $@$(X)
'''
2017-11-15 16:10 GMT+08:00 高增琦 :
> Hi,
>
> Recently, I found 'psql' is not rebuilt automaticall
LDFLAGS in the example changed to:
'''
override LDFLAGS := $(call expand_stlibs,$(STLIBS)) $(libpq_pgport)
$(LDFLAGS)
'''
2017-11-16 20:50 GMT+08:00 高增琦 :
> Is this a problem or not?
>
>
> A simple fix:
> 1. add a STLIBS variable in Makefiles
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
高增琦 于2017年11月16日 周四20:51写道：
> LDFLAGS in the example changed to:
>
> '''
> override LDFLAGS := $(call expand_
Hi, all
The attached patch trying to add dependency between client executes
and static libraries.
As described in message:
https://www.postgresql.org/message-id/flat/CAFmBtr1GDF%2BCpw%2B7SZF8jWGeazOd%3D%3DivRAg3rWhLaRXYCv83Vg%40mail.gmail.com#CAFmBtr1GDF+Cpw+7SZF8jWGeazOd==ivrag3rwhlarxycv8...@ma
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 flow of the conversation very hard
> to
The attached patch use normal dependency instead of order-only dependency
for static libraries.
2017-11-20 12:58 GMT+08:00 高增琦 :
>
>
> 2017-11-20 2:25 GMT+08:00 Tom Lane :
>
>> =?UTF-8?B?6auY5aKe55Cm?= writes:
>> > I very much look forward to hearing everyone's
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
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 高增琦 :
> The attached patch use normal dependency instead of order-o
12 matches
Mail list logo
