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.96) (envelope-from ) id 1wbjp5-002nv8-1z for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Jun 2026 18:56:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wbjp4-007emX-1K for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Jun 2026 18:56:42 +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.96) (envelope-from ) id 1wbjp4-007emO-0J for pgsql-hackers@lists.postgresql.org; Mon, 22 Jun 2026 18:56:42 +0000 Received: from mail-yw1-x112b.google.com ([2607:f8b0:4864:20::112b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wbjp2-00000001d4L-2aw5 for pgsql-hackers@lists.postgresql.org; Mon, 22 Jun 2026 18:56:40 +0000 Received: by mail-yw1-x112b.google.com with SMTP id 00721157ae682-7f69b71f7b2so51027257b3.1 for ; Mon, 22 Jun 2026 11:56:40 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782154598; cv=none; d=google.com; s=arc-20240605; b=T5ZMPELWtujc+bWkOnKRVXQ8mUheldKSy7fdIBfK/Pg13MWCD98BNDM2/JzHKvB8cn 6d8t3QuKKd7+glgw5R3h7lCOGr62KIwhvvwwVNp2yIJv3ZUNmgZNCz9FFWZzPqH4Ls4E GLPIKKUlz6AXXyG7kUJzTb9VVJSX5mWQjxwQqycIbnS/X+4eVNhF6irTUtXHZVGdr1f5 CtcF6i0hNLWxYlJIuMEePZR08wpiFAZSQ3lry10HabNXeN7jXBK3eRLD/i+EUrn9RaU9 6TEp0Lwv+fWljpEZcXBKkdzN5CI5SdTNrCyWahgjxaHEjjbiAADfCI711xrLrgrpzLjN pYEQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:mime-version:references:in-reply-to:from :dkim-signature; bh=DfOMfde832IkTsSlYWezcejE6BFzLlM1D8WBEtdySvc=; fh=nwNxTtLLPTU0ewfLM7SSbrjMajMl+wwnFkCY/fi90vE=; b=F4qhjNVMQGwVr2pMCFH5R1INQ4MkFF2drFk60JmHPdh4Ay+p4I22TtRWiMlsFlExZZ ENZxDpl4wPYY1cofQW0SIFc4dIZGsLXR7YGmLB+rLYSve5ggHUSuCRSn5V7UdNQ8ShtJ 3OltGww9oSLo/vJ7+pmqQIA+z5rsQhcsHtgXFUt951PsgMpS+bQAc5w1c68xN77fxFLQ sfVyLqh2k9AtBwOT8Vma3SxrZ0P95wSGs+j5BIos1KkhbvlEnjTCSeoYfbPA3f8yTJ9K U1RIwao0BV4ELrH+2EmJa3DhqVG2AyG2vpiHxDgeA2aU19uQ6P4AJYz6F8Y5Wwl7yEvR zYfg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=percona.com; s=google; t=1782154598; x=1782759398; darn=lists.postgresql.org; h=to:subject:message-id:date:mime-version:references:in-reply-to:from :from:to:cc:subject:date:message-id:reply-to; bh=DfOMfde832IkTsSlYWezcejE6BFzLlM1D8WBEtdySvc=; b=saHWRgwF8Za4vaijUDXWCgSUVNbVSU8lc4DqdnZHuAnSTOD/a5fZl0/2xH0rYnsl6D MglNIvocVRydIWchvecuYGD/2u5h6LbcGrMpd6UnDVZ5BodBn338MJ2Y4/ZfNa8k6r7p Mhm21wKGBJUkMvgV67PMGAinWnoj4jsXIhey3eFk7a7wjrJzhn0XTwFs7OeS1MPvCgP3 Z1cXXTwUVMvkAOziEd00a9BRL1hMgKwxKfYD7DPfdioy5JBxqj8bVmCt/DyWD1Gr0G9J EpUQiEYOxTXcO71PF5Jiw2dzKrCzL1ulXrQFPROre5fAvZr+g5EOGnI8HsgHPN49N0Ul sWyw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782154598; x=1782759398; h=to:subject:message-id:date:mime-version:references:in-reply-to:from :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=DfOMfde832IkTsSlYWezcejE6BFzLlM1D8WBEtdySvc=; b=pix+LB0sKYSOHurbQM6A9HnHKiV1+aMEZul8QgyzgAGVgYcE7/q9IFNZ/DxLa8A3nE nmOeBbNKfvdR11NkhsYDFvhjnSLmpNA9sGHcj2khAYn3/k3fBIt9M49JhGq4KoiyrtqL 1sFaCZvjcZDoSBjVklJY5P5kescbSoxaDL/aV9EFemOQFX7FQoZRbzN8E4wHU7KboRCU sCQ/4+Jq9nKcktpB6AOfuVKSAYYKHrLilEi47PZ0mCnCFLKEKCpCpshnTJnQdMEG64Bw mOA4F38gOS7R+AGQ0wwbNzlTEy+8lhs8tkfWso7Krh/RSUHda4UhVf2ThjhwDTXY/mFQ nkrg== X-Gm-Message-State: AOJu0YzNu6VQkuHPXgbzAqzFvJSZhH5HoSR055S9PFQqReszlq8m6eCp s4zN/bB7A/WrXsUZ2PDwwUCQTYnTP77rOgpgyJVXRLqWKxJyNr79oOTkqo7b7KOHB8zMUeQufu6 agyEaF7amlGLe01MYFkbZmVcE7ObEJrAu7CdDIMnP8CbkXZrqimDGPi802nKMd+ugiDq2Y6OOSp waSD9u7cwTgvMDlCnl4VFIGBnOny/Eyp1+ujhWOvluhG1T5KZPYUCuJUG4qqiN2q0ssv0RImA/a v9nYeHXxrm9hWFeCxCS03NOwO8DTAY+hHm5hRtMhuySZVh8fyYvl3Gd/8nB5dIb11GRBGdkN1tO Qw== X-Gm-Gg: AfdE7cmEH228RJJrUITvJPOwJRoMryTWn8erXERwnuTqJdR4rs/5mvvcM99VWVtKUU/ 5uvoz20K3ZLiBd6Ps6y8j827o5EZoQWYvaCeazz0sxZ+smLtezRIjgj9dUzXm+u4mzImQNKPNNT G1TOsYaXMnJe8ei56u7TgRDTNJcbtS0eYAtzlD6Bb0490qvZEUsMOBw1oTcVo5EN7TdWbpU5bKd BwAYoXuU+e3Nu0uJikw/RqPSS89MMNLxN/lGbd/wo7uTbRdAG4gyogvdcuOCMFb4TbT5W1QqG0t RUIrG8nfUTkDEPRGB5oXJQLPTFNhPlHRSUSIF/mEGRS977CBlNI6b+L/+g== X-Received: by 2002:a05:690c:4806:b0:7cf:af41:50b0 with SMTP id 00721157ae682-80133fc253amr148969567b3.36.1782154598408; Mon, 22 Jun 2026 11:56:38 -0700 (PDT) Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Mon, 22 Jun 2026 14:56:37 -0400 Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Mon, 22 Jun 2026 14:56:37 -0400 From: Zsolt Parragi In-Reply-To: References: MIME-Version: 1.0 Date: Mon, 22 Jun 2026 14:56:37 -0400 X-Gm-Features: AVVi8CdcZpT3Dq3dVyueLLFzZPTSoCPKvm7IDQ03pNTLIv7jAHy5VfzTi1qwOT4 Message-ID: Subject: Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements To: pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" X-CLOUD-SEC-AV-Sent: true X-CLOUD-SEC-AV-Info: percona,google_mail,monitor X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Thanks, I can confirm that only_foreign_keys works properly. > Combining `only_foreign_keys=true` with `includes_foreign_keys=false` is > rejected upfront since it would produce no output. Shouldn't only_foreign_keys=true with include_constraints=false also error out?