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.98.2) (envelope-from ) id 1xDh5x-00000000eck-2eL9 for pgsql-general@arkaria.postgresql.org; Mon, 05 Oct 2026 11:43:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xDh5w-00000009nCO-27Wy for pgsql-general@arkaria.postgresql.org; Mon, 05 Oct 2026 11:43:00 +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.98.2) (envelope-from ) id 1xDe2F-00000008nqw-3US9 for pgsql-general@lists.postgresql.org; Mon, 05 Oct 2026 08:26:59 +0000 Received: from mail-wr2-x0d.google.com ([2a00:1450:4864:30::d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xDe2D-00000000ROk-3x0u for pgsql-general@lists.postgresql.org; Mon, 05 Oct 2026 08:26:58 +0000 Received: by mail-wr2-x0d.google.com with SMTP id ffacd0b85a97d-48b9d8056d2so767638f8f.1 for ; Mon, 05 Oct 2026 01:26:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=20251104; t=1791188816; x=1791793616; darn=lists.postgresql.org; h=content-transfer-encoding:content-type:subject:to:content-language :user-agent:mime-version:date:message-id:from:from:to:cc:subject :date:message-id:reply-to:content-type; bh=Sxd8BaPpMvURRVsgUC7BMhUwhJWUXPyRyhHXs8XtFKw=; b=L0SIlL2nsgqqVu7wFqhVoIak03YxRQnL8vJZ5OsAL3/gdfpMuSVFEdkWwgTCz6LBPG LSoJVl2F3dSFNohDDCKE9lbaG1BdyMT8OfQmZrwyVwW7ZD6sGLDyY/V3h6HFeQTMn07d IaayriepWKAE+UQjuebiejYu7aXRJhLsW2QofwSOFwvp5GUEmOkJg9AgErb1RnE43j2E p7ANY7OUNFN/u/iKVtEmb4dyqVESeC9/WyUJ/ECFAlQJIhEskT38ZLSNzU02kE1IGE64 3z16qsjq5lu8+s2IQYURSczAbh8UXuzNkQhNkGP86/Lc4Czw+dcMRk3CegXz/SDKZ30A +z2g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1791188816; x=1791793616; h=content-transfer-encoding:content-type:subject:to:content-language :user-agent:mime-version:date:message-id:from:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=Sxd8BaPpMvURRVsgUC7BMhUwhJWUXPyRyhHXs8XtFKw=; b=fBUXaMuBMfMw57MQF9OJokQfyCtm3S5vcD4FPUgTCexT17Gz90X6UEgUE9mM70T48z xVsqN5Z+jWgqGd9fvuocKJnMT0RsH8VXaPVnaljXc5ABIkfNG3WVrNmnRgzXNAy/2fTO l7MoM1GkT06Uh7B0wqP6hwlicH/Nlevt+3nlhz4EY71RMwaU3piWMNCcYjEjoaBj7MCt gEzCqOmZpMMFaaY1mhjSVNv7JPWXz3K603oLq+kvvnk7SdpfeJcTl1cxVEy9dHP9pBCG SjsyCUSJakziELW8iKMjaqec+YTo6ljxRNBpo4hLviLiTbJu+ilMfB/+JAJUNfWvLYk7 5Dmg== X-Gm-Message-State: AFq9FYLzMh3RvYEFeKnfWdW8tFRxun1Q5wGaN4Q8luckEsXB8LnZlDtS TDw8tpJF9/XHY9ktsVgAEGCRTdmB6XtdxyrOJptbyv3HUun70C9B X-Gm-Gg: AYBFou2NbpHmmI13n5qUQoTdxGa6nUJeaHjjG8nEKIHFRqAOrogUo2qQsuzW5Y2i60g 9dud7eV9Rv7wGGHmexKMI79/EQxoFiuHczoGdTqpM9l2+S7bVFr8gLkzBU27rdEYnBEksX+XctH OCcpHZeSDRTRbHTh8tcB6Ysme1cpow75rq1LIZAQhBMjidmgd7hmJvXRptLzypaJHLrFQm+kEkc Ibom49+/VjSd5iBbecjFXpUjU44bYbPbgZbhdNLj6Ia9A7Hgl4PB9i/rlGB1wtsjg21PI/6u1EX 1uGQvSF2ZjFlPOs4LzbOoYRC3MahzCB0Iso8GNjJPGtX4C6j3kaw766UYPhR6YokUYhkuX2nQxm /dGvX2kboiDT1MVH9VAQFMxs2QfCstx64VIZbrzLVwT0cv/GCmgTd7WqHqw91XAdNUfS7cGQhAi hpleTN9g0av89iyECnO0aNUMUh5DIYF7gxyAhZ8WIZCZHDUWG7YXeEMaH0ZPOkQ+wVTGArWw7jl WCnTnIV2ETAV+uxNjZXwcPb+7XqFICK5sKDqVsr8lJuO6A73aAO7gJchfumxf/t1UYt X-Received: by 2002:a5d:470c:0:b0:487:27f6:a4e3 with SMTP id ffacd0b85a97d-48b1275cc02mr12997459f8f.51.1791188816440; Mon, 05 Oct 2026 01:26:56 -0700 (PDT) Received: from ?IPV6:2a01:41e3:5323:cf00:b1f0:2d33:55a9:23b0? ([2a01:41e3:5323:cf00:b1f0:2d33:55a9:23b0]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-48c622907fesm2179671f8f.26.2026.10.05.01.26.55 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 05 Oct 2026 01:26:56 -0700 (PDT) From: "Carl.Weierstrass" X-Google-Original-From: "Carl.Weierstrass" Message-ID: Date: Mon, 5 Oct 2026 10:26:55 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Content-Language: de-DE To: pgsql-general@lists.postgresql.org Subject: bug or feature Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, I want to delete some data from table test1 und protocol the deleted data in table test2: The solution with two statements begin; insert into test2 select * from test1 where 1 = 1; delete from test1 where 1 = 1 returning *;   -- show deleted lines commit; works fine, but the more elegant version in one single statement results in a syntax error begin; insert into test2 delete from test1 where 1 = 1 returning *;  --return deleted lines commit; psql:test.sql:32: FEHLER:  Syntaxfehler bei »delete« ZEILE 2: delete from test1 Is this a bug or a feature? Charly