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 1qnH1v-00AOTG-HH for pgsql-hackers@arkaria.postgresql.org; Mon, 02 Oct 2023 11:24:03 +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 1qnH1t-00En3x-43 for pgsql-hackers@arkaria.postgresql.org; Mon, 02 Oct 2023 11:24: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 1qnGcP-00Apte-Lf for pgsql-hackers@lists.postgresql.org; Mon, 02 Oct 2023 10:57:41 +0000 Received: from mail-wr1-x430.google.com ([2a00:1450:4864:20::430]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qnFkt-007lEt-BL for pgsql-hackers@postgresql.org; Mon, 02 Oct 2023 10:02:24 +0000 Received: by mail-wr1-x430.google.com with SMTP id ffacd0b85a97d-32003aae100so1701036f8f.0 for ; Mon, 02 Oct 2023 03:02:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1696240939; x=1696845739; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=gk9SROZxKJSpWoOjkBslGRptr+7QfTGhYLNe+5cjTuo=; b=Njo77bwt99WMTHKxVfIvq4CAZ89Cav0psixYuAYZSBY3kSCQRNQw1QS2juTV5UY1wh O5yYY/vAAT7rFBtDVLRmk8eaFkHaPdn+x27yDnC1np1xWAbfSbitvLotSz1OD2+Yr3/d PJkkogxoQR2BiJoees/KMZz/dU5zDPxp/EkRTBM2XyI9CECaGDwdtl569IKvMaEK3pOk H/fAWVC8UrPUxvcb6WcFN0wDfJmSifPcGUTcPRhOoVPTIp/mrhJ1aTYd2Hf3OWWuovUD r8wdVZ/BCj/Z7qI0PU7wJwx07Nlc+2McaTAIwgTGN7pHKBRMTcoCG2p6ciJlr6WSzn5n eS/w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1696240939; x=1696845739; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=gk9SROZxKJSpWoOjkBslGRptr+7QfTGhYLNe+5cjTuo=; b=IZvgohJJ3zgTq2QAeLaSMNadKOZyWW3QG3xrTvz6+QgM+EPbAe7xNPv2p8FJi8DNMW NjXi3u32tZ79l5gry1r7E2qx45IUesMk8vU/iffX+1KIf6s0AzRYcPn++wtF05GoCnXF MW+Jot941pAM4dTPzlSa+zyjkrLel1COm15YzsHDIr9MjpX1r6qyuvzU9p8s96GBR8s6 q4A/4Zt6uZgbcapjbZBlJikuZ+45M/stsRQnBCKcqYVBOJVkO48XEJPKDHx443L2b3SY uexQAsql988AaTXRyH1cYt87KuXONPkpS+CCVigftWVzvr9wSS+moVTXUb8vLuxHUwEj /Bvw== X-Gm-Message-State: AOJu0YzaDUWpkMKaERZLhmZgrky5mVlMXXgUUH/vKMlpcpa5r/gHYI3m YlmrrJOD6Sna1B1QcPU/xTX35uKCjBwbf4kxJ5k= X-Google-Smtp-Source: AGHT+IEyzlkpTlyLtF1yIBKRCauogF95tTB/A6z65cFb/2DHgzY+DsEN41gTcv85xzYCP2d3g+jLPQ== X-Received: by 2002:adf:e60c:0:b0:314:3e96:bd7e with SMTP id p12-20020adfe60c000000b003143e96bd7emr10016892wrm.4.1696240939004; Mon, 02 Oct 2023 03:02:19 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:6cf4:1982:ecd7:8449:ce90]) by smtp.gmail.com with ESMTPSA id b4-20020adfee84000000b003197c7d08ddsm6996335wro.71.2023.10.02.03.02.18 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 02 Oct 2023 03:02:18 -0700 (PDT) Message-ID: <7211a344cad10c517bb56ece3b86ae5d98be7d08.camel@cybertec.at> Subject: Re: Trigger violates foreign key constraint From: Laurenz Albe To: pgsql-hackers@postgresql.org Date: Mon, 02 Oct 2023 12:02:17 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Perhaps it would be enough to run "RI_FKey_noaction_del" after "RI_FKey_cascade_del", although that would impact the performance. Yours, Laurenz Albe