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
> 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
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