Re: order of pg_dump command "create sequence"

[Антон Глушаков <a.glushakov86@xxxxxxxxx>]

I absolutely agree.
Unfortunately, Postgres does not check the function code to see if it is really immutable

пт, 6 июн. 2025 г. в 16:54, David G. Johnston <david.g.johnston@xxxxxxxxx>:

On Friday, June 6, 2025, Антон Глушаков <a.glushakov86@xxxxxxxxx> wrote:

/* create a function that will move the sequence */

CREATE FUNCTION public.gen_id() RETURNS character varying
LANGUAGE sql IMMUTABLE AS
$$
SELECT 'PREFIX_'||nextval('public.my_seq'::regclass)::VARCHAR;
$$;

Stating immutable is a lie and the breakage is on your head for violating using only immutable functions in generated expressions.

David J.