Re: Context variable in application and trigger code

On 9/28/24 14:37, yudhi s wrote: Hi, We have a trigger function called from a trigger which executes before inserting rows in the table (say TAB1). This trigger function does some conversion of code to description and persists the description in the table in respective columns. We want to keep

Context variable in application and trigger code

Hi, We have a trigger function called from a trigger which executes before inserting rows in the table (say TAB1). This trigger function does some conversion of code to description and persists the description in the table in respective columns. We want to keep this trigger as light as possible as

Re: Synchronize the dump with a logical slot with --snapshot

Hi justin I raised question based on the reference link https://opensource-db.com/unlocking-initial-sync-for-logical-replication-in-aws-rds-for-postgresql/ .. you can also go through it to see the steps This worked on postgres 10version but on postgres 14 I can go through the info you provided t

Re: Synchronize the dump with a logical slot with --snapshot

On Sat, Sep 28, 2024 at 1:04 AM Durgamahesh Manne wrote: > Hi Team > > Can anyone respond to my question from respected team members ? > > Durga Mahesh > > On Thu, Sep 26, 2024 at 2:23 AM Durgamahesh Manne < > maheshpostgr...@gmail.com> wrote: > >> Hi Team >> >> --snapshot=snapshotname >> (Use th

Re: Grants not working on partitions

On 9/28/24 08:56, Lok P wrote: On Sat, Sep 28, 2024 at 8:46 PM Adrian Klaver > wrote: On 9/28/24 04:02, Lok P wrote: > Hi, > While we are creating any new tables, we used to give SELECT privilege > on the newly created tables using the

Re: Grants not working on partitions

On Sat, Sep 28, 2024 at 8:46 PM Adrian Klaver wrote: > On 9/28/24 04:02, Lok P wrote: > > Hi, > > While we are creating any new tables, we used to give SELECT privilege > > on the newly created tables using the below command. But we are seeing > > now , in case of partitioned tables even if we ha

Faster `&&` intersection for sorted arrays

I was wondering if I could do better than `&&` for sorted arrays by doing binary search and came up with some really interesting results. I only did a quick spin of this, an LLM generated most of the code after I gave it the algorithm and I don't plan on using it in production (I'm going to normali

Re: Grants not working on partitions

On 9/28/24 04:02, Lok P wrote: Hi, While we are creating any new tables, we used to give SELECT privilege on the newly created tables using the below command. But we are seeing now , in case of partitioned tables even if we had given the privileges in the same fashion, the user is not able to

Re: Regarding publish_via_partiton_root with pglogical

Please do not spam the mailing lists with requests for follow ups. In this particular case, you received an answer two days after you posted it. It went to both psql-general, pgsql-in-general, and to you directly, so there seems little excuse for missing it. Also note that pglogical is a third-par

Grants not working on partitions

Hi, While we are creating any new tables, we used to give SELECT privilege on the newly created tables using the below command. But we are seeing now , in case of partitioned tables even if we had given the privileges in the same fashion, the user is not able to query specific partitions but only t