Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sifh4-007mh4-Eh for pgsql-admin@arkaria.postgresql.org; Mon, 26 Aug 2024 19:48:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sifh2-00EQry-Fv for pgsql-admin@arkaria.postgresql.org; Mon, 26 Aug 2024 19:48:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sifh2-00EQrd-3S for pgsql-admin@lists.postgresql.org; Mon, 26 Aug 2024 19:48:00 +0000 Received: from mail-oo1-xc2d.google.com ([2607:f8b0:4864:20::c2d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sifh0-001ZOO-1C for pgsql-admin@lists.postgresql.org; Mon, 26 Aug 2024 19:47:59 +0000 Received: by mail-oo1-xc2d.google.com with SMTP id 006d021491bc7-5de92d2e9b3so1150831eaf.2 for ; Mon, 26 Aug 2024 12:47:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=crunchydata.com; s=google; t=1724701677; x=1725306477; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=UyIOitTkBfNfDeIQFDcuxuf3YBwYPoIpTdh34udqmMw=; b=fZ+jBSJ+oKnAOvRg9L/t0bl8AE65cQ5m2G1AHAr4ZhUGMcJlavc+6OpzfMEcbJBR7R 46at5vXcvmfXE1MHlAi59R7Qqv/w1OT+1EnNwI0EeSIMYX+fFH93FOCrOJG4Q5s8aOEZ kvdDhfy/42NU/tVekOaakqIEFV5XWxo82MT0OmN4swC7OvblbxfpNKbmpPYI3rFEDzfr 2ch/JoRTMZqmW+poLlaqNDPRZKD50nquPVNwlvkP16As3ZWKQpC7zy/7n0Tsdg3TL4Yc 9V7SauaEx6SfOc1CIGKwvstDqVcxmi2LZZWWI2J9tkotg0f4EF7+VACTRU/C6d8VsMn3 Pxhw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1724701677; x=1725306477; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=UyIOitTkBfNfDeIQFDcuxuf3YBwYPoIpTdh34udqmMw=; b=XgziYU97r05xpCMZO/CjvR2Xw3pGfAR4TlJeEISkopl78nlzdUAfXlHLo4ivxD95iJ F66+qrFzP8hIhxhk9ePdClU7cbBW8tp6tSc9XL3vnWD73DjWgaOsXY6jWKh16cnRcB6g ibn7l0J8hNOUpxh/axJcE16gw7s86flZ+4dub/9ILZ6/zD+D7kGlxODd7hssNxbfrNCK hY4eJ0IHX9vAqGZhkuwjrjOOYTPmELRNsil7JXWdfJINAjXqw+GQ8St8OxDy5Hrwoi+e IjhB4kw0dSSOtdzwXGWg+kR6uB3pmNFWNEf9rEIk+vow4An8TTu7bKthX6su6rEOZQjo r0Jg== X-Gm-Message-State: AOJu0Yx0pQJH6XWX3srtzT43+hTPO3lFUlH04xV6fdKTADq94cSjamKA suS1r8ewMjwLNcmFaeN6Wss0L0zmCYzzW/NZgP1VH7alwXWOtMV016w/Qst11CKj8Tt3PIBhR1Q 6OeCGZ2KkOUHIhkGOxYIRkhB0Emr4CKKoZ6iry77tai5mhNNX X-Google-Smtp-Source: AGHT+IEGkNsZEA4fd3DaIVvgSeywz3oYkf3/4VYPvjN6jJDkjL5O5CggENRC7n9MYG2mk4bioyrUuZ+3aN1dQXEfU+E= X-Received: by 2002:a05:6820:160e:b0:5da:a06b:c405 with SMTP id 006d021491bc7-5dea6536cf6mr1187449eaf.0.1724701677413; Mon, 26 Aug 2024 12:47:57 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Keith Fiske Date: Mon, 26 Aug 2024 15:47:31 -0400 Message-ID: Subject: Re: Pg partman To: Sathish Reddy Cc: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000d37de406209b66c3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d37de406209b66c3 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Aug 26, 2024 at 3:36=E2=80=AFPM Sathish Reddy < sathishreddy.postgresql@gmail.com> wrote: > Please share the script which used.. > > Thanks > Sathish Reddy > > On Tue, Aug 27, 2024, 12:11=E2=80=AFAM Keith Fiske > wrote: > >> >> >> On Mon, Aug 26, 2024 at 2:13=E2=80=AFPM Sathish Reddy < >> sathishreddy.postgresql@gmail.com> wrote: >> >>> Hi >>> We are planning to create function like run_maintance_proc which can >>> do detach partition concurrently and create new partion s using pre-mak= e in >>> run maintenance.. >>> >>> Please share any use case on these.. >>> >>> Thanks >>> Sathish Reddy >>> >> >> You cannot create a function or procedure within the database that can d= o >> any commands with the CONCURRENT flag. PostgreSQL simply does not allow >> that otherwise I would have done it already. As I stated elsewhere, this >> would require an external script >> >> https://github.com/pgpartman/pg_partman/issues/677 >> >> -- >> Keith Fiske >> Senior Database Engineer >> Crunchy Data - http://crunchydata.com >> > There are no scripts written for this yet. --=20 Keith Fiske Senior Database Engineer Crunchy Data - http://crunchydata.com --000000000000d37de406209b66c3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Mon, Aug 26, 2024 at 3:36=E2=80=AF= PM Sathish Reddy <s= athishreddy.postgresql@gmail.com> wrote:

Please share the script whi= ch used..

Thanks
Sathish Reddy


On Tue= , Aug 27, 2024, 12:11=E2=80=AFAM Keith Fiske <keith.fiske@crunchydata.com> = wrote:


On Mon, Aug 26, 2024 at 2:13=E2=80=AFPM Sathi= sh Reddy <sathishreddy.postgresql@gmail.com> wrote= :
Hi=C2=A0
=C2=A0 We are planning to create function lik= e run_maintance_proc which can do detach partition concurrently and create = new partion s using pre-make in run maintenance..
=C2=A0 =C2=A0 Please share any use case on these.= .

Thanks=C2=A0
Sathish Reddy=C2=A0

You cannot create a function or p= rocedure within the database that can=20 do any commands with the CONCURRENT flag. PostgreSQL=20 simply does not allow that otherwise I would have done it already. As I sta= ted elsewhere, this would require an external script


--
Keith Fiske
Senior Database Engineer
Crunchy D= ata - http://crunchydata.com


There are no scrip= ts written for this yet.

--
Keith Fiske
Senior Database Engineer
C= runchy Data - http://c= runchydata.com
--000000000000d37de406209b66c3--