Re: Enables to call Unregister*XactCallback() in Call*XactCallback()

callback when the callback finishes to implement run callback once and unregister in one place. Regards, Hao Wu

Enables to call Unregister*XactCallback() in Call*XactCallback()

T_SUB)) { /* to do some cleanup for subtransaction */ ... UnregisterSubXactCallback(AtEOXact_cleanup_state, arg); } } ``` Regards, Hao Wu safely-delete-callback.diff Description: Binary data

Re: HotStandbyActive() issue in postgres

real hot standby. Does it make sense? Regards, Hao Wu

HotStandbyActive() issue in postgres

StandbyActive to false when the recovery process almost finishes. See the attachment. Regards, Hao Wu fix-hot-standby.diff Description: fix-hot-standby.diff

Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY

TABLE ATTACH PARTITION 2: insert into tpart values (110,110),(120,120),(150,150); 1: end; 2: select * from tpart_default; 2: end; After that the partition tpart_default contains (110,110),(120,120),(150,150) inserted in session 2, which obviously violates the partition constraint. Regards, Hao Wu

Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY

the failing row contains (i) = (130). Is this an expected behavior? Regards, Hao Wu From: Robert Haas Sent: Thursday, August 27, 2020 11:46 PM To: Alvaro Herrera Cc: Pg Hackers Subject: Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY On Wed, Aug 26,

Missing unknown status in PGresult

;t get any response from the server, so it may succeed or fail. Regards, Hao Wu

Rewrite view?

--+--+-+--+- a | character varying | | | | extended | View definition: SELECT foobar.a FROM foobar WHERE foobar.a::text = ANY (ARRAY['foo'::text, 'bar'::text]); My question is that is it an expected behavior or not? Thank you. Regards, Hao Wu

Re: Add test case for sslinfo

e are other ways to determine this environment. Thank you very much! On Mon, Jul 8, 2019 at 12:05 PM Thomas Munro wrote: > On Mon, Jul 8, 2019 at 2:59 PM Hao Wu wrote: > > I see there is no test case for sslinfo. I have added a test case for it > in my project. > > Hi Hao

Add test case for sslinfo

Hi Hackers, I see there is no test case for sslinfo. I have added a test case for it in my project. Do you mind if I apply this test case to postgresql? Best regards, Hao Wu 0001-Add-certificates-keys-and-test-cases-for-contrib-ssl.patch Description: Binary data

Where to save data used by extension ?

Hi pgsql-hackers, I have an extension for postgresql. The extension works across some databases, and needs to save some data. The data might be modified dynamically by the extension, and all the changed result must be saved. I have considered some methods. 1. Use GUC I find no easy way to write th