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 1r13uG-0097U2-Db for pgsql-admin@arkaria.postgresql.org; Thu, 09 Nov 2023 12:13:08 +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 1r13uF-00DcJE-2G for pgsql-admin@arkaria.postgresql.org; Thu, 09 Nov 2023 12:13:07 +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 1r13uE-00DcJ6-NQ for pgsql-admin@lists.postgresql.org; Thu, 09 Nov 2023 12:13:06 +0000 Received: from mail-yw1-x112c.google.com ([2607:f8b0:4864:20::112c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r13u9-005WrH-Qf for pgsql-admin@lists.postgresql.org; Thu, 09 Nov 2023 12:13:06 +0000 Received: by mail-yw1-x112c.google.com with SMTP id 00721157ae682-5ac376d311aso9213207b3.1 for ; Thu, 09 Nov 2023 04:13:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1699531980; x=1700136780; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=zb+hTRULKbgfMG9F0K5pY5UeK9QovvmkpFLWIM0IP0c=; b=NXYGeNy5y+zvkRvp0To1P3ahs9QdId7ORgXwQMcVpE0ADNIZ/Qn558iwlD1k8CNN7B 5oRF7dhdqizR61d7X1MpV4uty6eN41OqbtgvX+4XQduHb0ewq4yC78DDBQVTo6lLVS4j JIJVEz6ni1jfyeaqhOTWnPFc96iCsayXN9xqHEIXt6BxhHd3m/JnHB8moCec5Jfe1GhP uOAWFVEzJC328zGpxW68YnBelJJblAfpzYOpCPTEP7aaelvLPXhuKOZ/00hri58cvwF4 Xl8flMkXIzMAfMKj4yCTPYacVlNXbBqnmlL2p4dGW19Rx251GD2hItGCcjD5T+RHFRdf PJng== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699531980; x=1700136780; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=zb+hTRULKbgfMG9F0K5pY5UeK9QovvmkpFLWIM0IP0c=; b=K+oIwXC3qtlZ9Q9QUEqtGPq6tI0WyM1f/V/X3gOEMBD7r1vAqmw1m42RWfshpq04Nc HxZ3OGgUXI/bD/j3IimGeFpGLks6OBRuaSUxIqonPy7qLFkKYWRHAKdEG6raSSsMvqdi OAkuJ2WBIx/HiP3Apc11yrc/VPemjqa5RPTsbjjE1aO7KT8c3s+EcMuB2jpVGmWsEMy/ 8pj3WZ6ZiNdo2p48jhM1N5UglTbbV8f1GNdadjVP2u+3jI1QgJrazQ603O6r2ywj5+x0 FNwHiZx3V1qjLqxFzi7Oq4avLqQytDbDkbetq1xZbBA0WY3yJhchdeN55te8SpYpebBp zjUQ== X-Gm-Message-State: AOJu0YwmXc1+Lshd61GJ5zudYwrqw/Kpy9dfW+0a8Hp8TEILPHtLgXan 7HBfyLbutehit/TybbmJyNJujbCSRX8= X-Google-Smtp-Source: AGHT+IErEHOtojHWIWGN4GrNGEoi3DBMXqQLTzZ0k4ZD3alsB205hXWFu8Yrkw6xUis22p/p+1gLTw== X-Received: by 2002:a81:4a0a:0:b0:583:d8d4:7dfe with SMTP id x10-20020a814a0a000000b00583d8d47dfemr4788652ywa.31.1699531979860; Thu, 09 Nov 2023 04:12:59 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::44? ([2600:1700:bd2c:b810::44]) by smtp.googlemail.com with ESMTPSA id w6-20020a817b06000000b0055a07e36659sm7809450ywc.145.2023.11.09.04.12.59 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 09 Nov 2023 04:12:59 -0800 (PST) Message-ID: Date: Thu, 9 Nov 2023 06:12:58 -0600 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Foreign key constraints on partition tables Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: From: Ron In-Reply-To: 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 On 11/8/23 23:54, Daulat wrote: > Hello Team, > > Would you please help how we can create foreign keys on partition tables > in Postgres14. What happened when you tried adding the FK to the parent table? -- Born in Arizona, moved to Babylonia.