Re: alter table rename column can event trigger capture new column name

On Mon, Apr 24, 2023 at 10:46 AM jian he wrote: > > hi. > alter table t1 rename col1 to id. > > Is it possible to use an event trigger to capture the new column name > "id"? > > > sorry for the noise. I figured it out. substring(_object_identity FROM (LENGTH(_object_identity) + 2 - STRPOS(REVERSE

alter table rename column can event trigger capture new column name

hi. alter table t1 rename col1 to id. Is it possible to use an event trigger to capture the new column name "id"?

Replicating / Updating Materialized views across databases

Hi, I have large centralized master database for which I created a few materialized views exclusively used by Web sites running in different regions on their own servers. To avoid having to connect to and pull data from across the globe I am thinking about running small postgres instances in each

Re: Why not use the calloc to replace malloc?

Thorsten Glaser writes: > On Sat, 22 Apr 2023, Tom Lane wrote: >> The maintenance benefits are real though. > Oh, interesting ;-) Thanks for this explanation. > Another data point is: calloc is not correct for pointer fields, > you have to manually assign NULL to them afterwards still, because >

Re: Why not use the calloc to replace malloc?

On Sat, 22 Apr 2023, Tom Lane wrote: >Wen Yi writes: >> [ use calloc to replace zeroing fields individually ] […] >People have complained about this practice off-and-on, but no one has >provided any evidence that there's a significant performance cost. >The maintenance benefits are real though.