Re: order of pg_dump command "create sequence"

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Антон Глушаков <a(dot)glushakov86(at)gmail(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: order of pg_dump command "create sequence"
Date: 2025-06-06 13:54:07
Message-ID: CAKFQuwYXJ11+wMu-qrLi9yQwZYjDsgJH=h6aStyxcHti=gYC+g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Friday, June 6, 2025, Антон Глушаков <a(dot)glushakov86(at)gmail(dot)com> 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-06-06 14:07:47 Re: order of pg_dump command "create sequence"
Previous Message Антон Глушаков 2025-06-06 09:15:45 order of pg_dump command "create sequence"