Re: [EXTERNAL] Oracle FDW version

Hello, I already installed your extension. As of now, I'm having issues in creating the oracle_fdw. Please advise. Thanks! postgres=# create extension oracle_fdw; ERROR: query plan with multiple segworker groups is not supported HINT: likely caused by a function that reads or modifies data in a

Re: pg_dump/pg_restore and the magic of the search_path

> On 31/08/2023 17:08 CEST Arthur Bazin wrote: > > Consider that we have a function in the public schema witch is named > my_function_in_public. > > In PG11 this table : > CREATE TABLE public.test_dump ( > id TEXT DEFAULT my_function_in_public() > ); > When you dump this table with the pg11 binar

pg_dump/pg_restore and the magic of the search_path

Hi everyone ! I have a good question on pg_dump/pg_restore and the search_path. Consider that we have a function in the public schema witch is named my_function_in_public. In PG11 this table : CREATE TABLE public.test_dump ( id TEXT DEFAULT my_function_in_public() ); When you dump this tab

Re: pg_visible_in_snapshot clarification

On Mon, Aug 28, 2023 at 8:34 PM Mike Roest wrote: > I think this has to do with the pg_current_snapshot not showing the > transaction in the xip_list which appears to be empty on both C1 (in the > transaction) and C3 on the replica. However C2 pg_current_snapshot() does > show C1 xactid as in

Re: event trigger clarification

Thanks ! Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Wed, Aug 30, 2023 at 6:18 PM Erik Wienhold wrote: > > On 30/08/2023 17:12 CEST Marc Millas wrote: > > > > the doc v15 states: " pg_event_trigger_ddl_commands returns a list of DDL > > commands executed by each user action, w

Re: event trigger clarification

Thanks ! Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Wed, Aug 30, 2023 at 8:44 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, August 30, 2023, Marc Millas wrote: > >> Hi, >> the doc v15 states: " pg_event_trigger_ddl_commands returns a list of DDL >>