Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1laxA0-0003mQ-8F for pgadmin-hackers@arkaria.postgresql.org; Mon, 26 Apr 2021 09:04:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lax9z-0004DA-5m for pgadmin-hackers@arkaria.postgresql.org; Mon, 26 Apr 2021 09:04:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lax9y-0004D3-SA for pgadmin-hackers@lists.postgresql.org; Mon, 26 Apr 2021 09:04:07 +0000 Received: from mail-il1-x12f.google.com ([2607:f8b0:4864:20::12f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lax9v-00046T-76 for pgadmin-hackers@postgresql.org; Mon, 26 Apr 2021 09:04:06 +0000 Received: by mail-il1-x12f.google.com with SMTP id v13so6242971ilj.8 for ; Mon, 26 Apr 2021 02:04:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=PBILWlfM7ClISMZA5a/eIHtYBvayfHu4NWdAlQ7uM+U=; b=R3xaR+khD41J8A5SRJnPa55VDjr0SnM1ABIi6BJe+v+t5dPp87ZFjtE9mQkxgYT64k 5aSkSp5oA+BmRrbI2lvGz0XqBIuNGeD2uZlFjrwn4/Z89B5ml93zc2clGo8eBvPWVIND YYXPbad0B4Qzf1MSUzrgiHhQpFmzkqsYO3ucBvxADrQeQ9pTl4bS1LnqCbdc2sM5A0Xk 6ECwLku989bcBbUVUndUgOLQpno4d58Np/McJX2sMkH+rnWN0y3wvVNpwli25GKy/5PC +jYpJJEMmH9nof/HbeV79c1AtISYJp0ibI3KPnPLQ9XSmGrELoag4F1IYoanFzbrZvZO COXw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=PBILWlfM7ClISMZA5a/eIHtYBvayfHu4NWdAlQ7uM+U=; b=EqQErYLxpQYana0LwZmrOs8DL2Kji9coI6WcOIe+tH4wiQg/LANxoutOl7SDIFMcQr IyJlHCG5QlC3OvgZGpi7T57QyzjWoYq5Yc/b29KVM+C9JKvd7mZU72g2lZIifwNCLZEa heuTwklB/uZpyZSbh3zv6j+2qxSO99gY1mgBRUCseoh0sR3XBTqZiWAygND8mDRn1jod ii0JxXxjizvICwn67NpIuZjz6h8S+eZM1wqY+gtB5Vc4lYnJJu0ycKTA/cYJHX0yaNjp zJ9iicpfwQy+FmzSHu67v7IIO8Z79lPbALanxyYgzpD30aG5IaOCekZ4wXur635EnHtz EGng== X-Gm-Message-State: AOAM533f5QKYTQPGOdEQ8s3m+mRebY8ERebzNbqrSJ1WDihKCW9Yw1Sl DlhZblrt2YJ0jwd5GCwHPA8d3GarBXF+fbf89FwcleaDD2mz6Qsju5Xa4N+FT63vOjIaX/LLqxS Y6ESd35nNLNftvW/ANBLr8A6TdnMQRTM6+fhFYBq2vv4uPNeYP/Iyt6yJspJDhIuBcqmK8qtYm7 FIhl764SEXbxQv8+YqQX1BFZ+3PwhTMthMHOILnmyomRQdWhH71neW9aHDGQ== X-Google-Smtp-Source: ABdhPJy5kUMzwA8vljqBOlXH77Vq5GvdA+y/wrXghEOprfPrDkAxMIrI+hrboPzyu+dg5wcfbp+Sh3BCMAYBPCGzha8= X-Received: by 2002:a92:6607:: with SMTP id a7mr1557567ilc.121.1619427841181; Mon, 26 Apr 2021 02:04:01 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Akshay Joshi Date: Mon, 26 Apr 2021 14:33:50 +0530 Message-ID: Subject: Re: [pgAdmin][patch] RM6329 [SQL] bad child table DDL To: Rahul Shirsat Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="00000000000036a09105c0dc6d10" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000036a09105c0dc6d10 Content-Type: text/plain; charset="UTF-8" Thanks, patch applied. On Fri, Apr 23, 2021 at 2:08 PM Rahul Shirsat < rahul.shirsat@enterprisedb.com> wrote: > Hi Hackers, > > Please find below patch which resolves the issue of inherited key > constraint getting in partition SQL. > > Simultaneously, added the partition table's RLS policy, Triggers, Rules, > Compound Triggers in the main SQL tab as previously it was not included. > > -- > *Rahul Shirsat* > Senior Software Engineer | EnterpriseDB Corporation. > -- *Thanks & Regards* *Akshay Joshi* *pgAdmin Hacker | Principal Software Architect* *EDB Postgres * *Mobile: +91 976-788-8246* --00000000000036a09105c0dc6d10 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks, patch applied.

On Fri, Apr 23, 2021 at 2:08 PM Rahu= l Shirsat <rahul.shirs= at@enterprisedb.com> wrote:
Hi Hackers,

Please f= ind below patch which resolves the issue of inherited key constraint gettin= g in partition SQL.

Simultaneously, added the part= ition table's RLS policy, Triggers, Rules, Compound Triggers in the mai= n SQL tab as previously it was not included.

--
=
Rahul Shirsat
Sen= ior Software Engineer=C2=A0|=C2=A0EnterpriseDB=C2=A0Corporation.


--
Thanks & Regards
Akshay Joshi
pgAdmi= n Hacker | Principal Software Architect
EDB Postgres
Mobile: +91 976-788-8246

--00000000000036a09105c0dc6d10--