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 1r0GXW-004fGU-Ne for pgsql-admin@arkaria.postgresql.org; Tue, 07 Nov 2023 07:30:22 +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 1r0GXV-005nf9-3c for pgsql-admin@arkaria.postgresql.org; Tue, 07 Nov 2023 07:30:21 +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 1r0GXU-005nbc-JI for pgsql-admin@lists.postgresql.org; Tue, 07 Nov 2023 07:30:20 +0000 Received: from mail-ej1-x636.google.com ([2a00:1450:4864:20::636]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r0GXS-0058XA-0P for pgsql-admin@lists.postgresql.org; Tue, 07 Nov 2023 07:30:19 +0000 Received: by mail-ej1-x636.google.com with SMTP id a640c23a62f3a-9e2838bcb5eso27861666b.0 for ; Mon, 06 Nov 2023 23:30:17 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1699342217; x=1699947017; darn=lists.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=tVxrfclUpjFVlG7kg3eby/39KjEkpVEurWcx7MeOpG8=; b=t9hagIc7+CbePgP9vmjfKeVeKWPdz63dvwDtxmUVRlTvpBjPZtY0n6cIBH7xDGUB0V nMqCr4P5QP1aTixqhR8MPxukDhwEGPBgLaD9CQlBDtoqIoIsoFWqTorUnEIt+kjidnFI OShEjWZtNHbikGe/CYMoOpX6GDPrUVrn10Q2ung//c/Lq90XsV+UNb8tafhPOHeGDz3J vmJhtu3ERdTCjv75WHoDJ+Kj7YVrOGxYG4kNuXfIxXE+iXwmdTCobGhU/s1DGKwx1ZDJ 3ZLFvI2tMO1rh3s35j3j8P2awntkEbfLEewoAiITc9bQS8lfHK/dafscl2Ow4hLlFYt2 +ucg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699342217; x=1699947017; 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=tVxrfclUpjFVlG7kg3eby/39KjEkpVEurWcx7MeOpG8=; b=fwRr2dv9P48u4eizYDilc5ibpcOGerkG3cLdpof5esUmwxOpyV8Im+aYRGztgrMvzp HGstnXqi2DQS7ySWiWZRS2ayaHLj4gryP29PKxEVEAnRXthuVhuF83dOy+efJJFSzp+Y jM83R/uVzMO0fqaSx73qWRVdLI402guw9ic9xGdY51KqNiwdXgDVf9K8GpMrbkL3DbGS GOO/c4mW3lDj5HpAPk9mapwVvIUZlRkR3n0iY+QUsaINOIq/xADBmReKfcBFHSOw8Cz3 BPemaOWvSvYQBX/RWZM9TI1I1juUlv4yZpeSu7MnHYQx5zYHMNel4vMG8vi/OeAQwP7X BN5w== X-Gm-Message-State: AOJu0Yx0gTF1Ul3beYja3jsP3ecPMN0HtDGT/c52FYQCQ09eko96CM+k q05CTpSWpDb3a7wEKZwVFUfz16LKPr82FdoE8Yop2Q== X-Google-Smtp-Source: AGHT+IHL/huoIWJutrZbx1JO2YxmOeIc85qhUXVIqYTR/MiwghH5OxRdF/EkNOYV3yKPt1BJwBfN4w== X-Received: by 2002:a17:907:6e86:b0:9be:d55a:81c5 with SMTP id sh6-20020a1709076e8600b009bed55a81c5mr16149602ejc.60.1699342216493; Mon, 06 Nov 2023 23:30:16 -0800 (PST) Received: from localhost.localdomain ([2001:871:5e:b8da:b3d:3b21:d0f0:fe1d]) by smtp.gmail.com with ESMTPSA id ox11-20020a170907100b00b009dd949b75c7sm703913ejb.151.2023.11.06.23.30.15 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 06 Nov 2023 23:30:16 -0800 (PST) Message-ID: <5031db5a11ea0e29b16b4a08e7dd0a3f67f55444.camel@cybertec.at> Subject: Re: TRIGGER on a FOREIGN Table? From: Laurenz Albe To: Sbob , Pgsql-admin Date: Tue, 07 Nov 2023 08:30:15 +0100 In-Reply-To: <0c27ded3-4cf5-45a6-b186-41f75778f625@quadratum-braccas.com> References: <0c27ded3-4cf5-45a6-b186-41f75778f625@quadratum-braccas.com> 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 On Mon, 2023-11-06 at 21:15 -0700, Sbob wrote: > does anyone know: can I create a trigger on a foreign table? I suspect I= =20 > have to create the trigger on the remote / source table yes? You can create a trigger on a foreign table. But don't get confused: - the trigger will run locally, not on the remote database - the trigger will not run if the table on the remote database is modified Yours, Laurenz Albe