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 1riYuH-000IUK-U6 for pgsql-sql@arkaria.postgresql.org; Fri, 08 Mar 2024 12:00:58 +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 1riYuG-00CQei-7I for pgsql-sql@arkaria.postgresql.org; Fri, 08 Mar 2024 12:00:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1riYuF-00CQeZ-S9 for pgsql-sql@lists.postgresql.org; Fri, 08 Mar 2024 12:00:56 +0000 Received: from mail-oa1-x2a.google.com ([2001:4860:4864:20::2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1riYuC-003Que-UY for pgsql-sql@lists.postgresql.org; Fri, 08 Mar 2024 12:00:55 +0000 Received: by mail-oa1-x2a.google.com with SMTP id 586e51a60fabf-21e8a740439so1175553fac.1 for ; Fri, 08 Mar 2024 04:00:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1709899251; x=1710504051; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=Xdn2X3rnUvunqnVJWUkVgm3kwDvDWHh0vSjRj9XBTm4=; b=RzgqF8OxMYbdzY7A5BmUopeF80xuumQ7VZG9gQy30GfKeNpls9KoB5DKMVnAM3cxby AFKKFI+XoXd3OoW9VZw3qSgABY6DqKXgjepEOIHOyCp+34Hw2Cjnn31/4z4RE3ImHGd+ B8rXG+JdgVMwIwcwesgStTjZPNRhOtUwdyj4DdH4wZOr9axSRHjN9qYXpu8YJ7tWSgZN Mwq7oIoE831cPvCu9eHicOTba9AdAdG0JsJYa6e7iiO6cqOHTxIEJxUy6ZECT9UdjTZP tSnBEhpoqFRMk2E/GR4izdTB+sgbGsN830aH+emJaXjRk/fAQfA4pukarW37deEGzfu+ IpSA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1709899251; x=1710504051; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=Xdn2X3rnUvunqnVJWUkVgm3kwDvDWHh0vSjRj9XBTm4=; b=M95hQwBS5FfbAyxwpp4RRbWy3Z0x/6wV3gsxTTVgxtT0y1N7SAXVKPNeiaxpPeGW0I TkxlJSw7R1Vnu8dV/7A8JBUEHTCCXBF9LDlvXN0nn01QtOHI4LedzqEalSnlYBeJ8uY9 wN40i4n+GSpEJg+GbVRz2lREV7PPzjaWjhJwRw6WBG1kXBVPWwln1gZvrxugU6+h/nl9 70u8rKRMN302pg/l+6DSuZf9uxnO2FTjk0I8V6OJLueZktqK3jRtYswx7Ckz70H6SoX8 XIadVmLeB1MKB6cNBLzi7LcDCfRZCsrW1Y2+ofUd5hbPnf3yKc2Mbg3FOVMcq6pMKD+o HHaw== X-Gm-Message-State: AOJu0YyoN8fOyWbt4AyOqhMOVKXGWY03gil5Tn5zShn3aSkamoBkLsLh +7UTNIpks58bnOstfXLSl20sUCQkkvU0+sqAmu/emhzXAqY03ddKjrjwZPvOUQ4Sey4T/cXgPEY GbL/tK1d0zzJIdX6bzXgzPUKTCg/0iTQRbyE= X-Google-Smtp-Source: AGHT+IEzNx5xabn3cJz6QXXxBD2T3Jzzl7cEIWKCbPdtC6OZn1yjt99FxmUArezBFDETwaFx5QU+sZUU9hEqzIYrlvw= X-Received: by 2002:a05:6870:a449:b0:21e:5257:906a with SMTP id n9-20020a056870a44900b0021e5257906amr7778oal.2.1709899250708; Fri, 08 Mar 2024 04:00:50 -0800 (PST) MIME-Version: 1.0 From: intmail01 Date: Fri, 8 Mar 2024 15:01:11 +0300 Message-ID: Subject: How to know if all insertions are finished To: pgsql-sql@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000070c0c4061324f146" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000070c0c4061324f146 Content-Type: text/plain; charset="UTF-8" Hi, Is there any way to know if several insertion are terminated. I use libreoffice base to import at the same time many lines. When all lines are inserted I have to do some data check. I dont find any way to know if the insertion ends to start some function automatically. I tried to use a STATEMENT trigger type but all lines are treated as statement. --00000000000070c0c4061324f146 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Is there any way to know = if several insertion are terminated.
I use libreoffice base to im= port at the same time many lines. When all lines are inserted I have to do = some data check. I dont find any way to know if the insertion ends to start= some function automatically.
I tried to use a STATEMENT trigger = type but all lines are treated as statement.
--00000000000070c0c4061324f146--