Re: pg_dump/pg_restore and the magic of the search_path

2023-09-05 Thread Arthur Bazin
Hi, thanks for your answer ! Sorry for being late... I'm sure :-) But I made more research and find the problem : the function I use... I'm using the gen_random_uuid() function wich is included into postgresql core since v13 and was originally into the pgcrypto extension. So when you don't prefi

Re: pg_dump/pg_restore and the magic of the search_path

2023-08-31 Thread Erik Wienhold
> 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

2023-08-31 Thread Arthur Bazin
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