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 1msOhE-0000yj-CU for pgadmin-hackers@arkaria.postgresql.org; Wed, 01 Dec 2021 12:26:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1msOhD-0006GC-6q for pgadmin-hackers@arkaria.postgresql.org; Wed, 01 Dec 2021 12:26:47 +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 1msOhC-0006G2-J4 for pgadmin-hackers@lists.postgresql.org; Wed, 01 Dec 2021 12:26:46 +0000 Received: from mail-ua1-x933.google.com ([2607:f8b0:4864:20::933]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1msOh6-0006dA-RO for pgadmin-hackers@postgresql.org; Wed, 01 Dec 2021 12:26:46 +0000 Received: by mail-ua1-x933.google.com with SMTP id l24so48618300uak.2 for ; Wed, 01 Dec 2021 04:26:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=dq1zoC1lStDtnp3pa6PdrrxjUUd39DznzA7ogl6OfZc=; b=X40qGBW2QHAYGYJ+utOoRwQdFbjAtrIcdPOiFd1aiNUwgEP6MfIUFxS36ThfJ43DJU cHhIVDs4KwbxveDt8HKOwYEK9445BMY2SIhegbTYNXKMf+3tKCoXkLt1E31I4sWj7cc1 s/GQWlqHTsKxhls5QyBrQ+ff2gVy8LDyEgYXwJaISW3wAdof41naHFimCMc1ESa09AF1 WJ/XQXisp34detYH9SwJ5AV1OAgwD4hQYStQrGqagvkWX9g9ZcjYCZHAzaF+HFcxmLsa pr8Ny8jRMJ0DNXhetEeNPeXGIU170Tg5GyUn4w2b6jRN4e/PRbifz7KskcGfV7zSfYsd tZQA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=dq1zoC1lStDtnp3pa6PdrrxjUUd39DznzA7ogl6OfZc=; b=ThmvHqqD8eqXBunzyhNAxkrD6SQYgZ6Gs9x6B9zmcOcd+5YTebIcd4JH27gzp7dbo4 zQBtcuXTBQAaNv0C3wtGxOxg6WR8ZWPwtqKHCeTcgvnmRDdRy3QGMUInQEGRpEsiRdGe xgjTVQ+xJRYmCZYjMgsb4vdM8uFbSOV8Elmzq8VfNsZqffhqd6YG7ZxXzff/JKrMve3P r//jWOTDkZY/B8XCk/1F+GQJFFXg92FhAVILoZfAbKcRzjH5+BqbSW5ggN64oCzvGgTv IAgO8zp9gSgfFDLDzVMQrXYBLPYybMm5WpllaePzNMBkDGaLSVibHXKY1CTCcQvYTsh3 d3OA== X-Gm-Message-State: AOAM5301Ae/iwOGCEkFu86XX9NdI8vanGyOdHeunIl9e/xYf94mJdHqD GdzQ1S/C64RRdSgi89ZOxXpKfVIs2aDzF0EO16hrH/zWrLan6jiyUjZxDqkLSvsigfUm4O5+eHu OXCMRdKI30ccozwtxCS4Ys1nbgI5TD0/K9OfD1twPB0HPQshtrESrjZgatLyUaiGlr4pr+ohvBO qL5rdsjeyWPd7ue7WODOwT/TSzRS+SuzShe0cdmjUxW1jM+iWfdBMFCQksBg== X-Google-Smtp-Source: ABdhPJwXmZmNAdM8JSqwBmW6XM9OIDp/3Q7MMfUsLAnuTb+4v8/9pj7MZ63yjDHRH65Lr5dchvPpC8MzrWaSsYYzNVo= X-Received: by 2002:ab0:35cd:: with SMTP id x13mr6938345uat.46.1638361599112; Wed, 01 Dec 2021 04:26:39 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Aditya Toshniwal Date: Wed, 1 Dec 2021 17:56:02 +0530 Message-ID: Subject: Re: [pgAdmin][RM7031]: Database definition wrong To: Pradip Parkale Cc: pgadmin-hackers , Akshay Joshi Content-Type: multipart/alternative; boundary="000000000000210e2405d214c92e" 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 --000000000000210e2405d214c92e Content-Type: text/plain; charset="UTF-8" Hi Pradip, You did not include the server_old table for query_history. Please also remove the commented code: + # db.engine.execute("PRAGMA foreign_keys=ON") + + # db.session.commit() + + # db.engine.execute("PRAGMA foreign_keys=ON") + On Wed, Dec 1, 2021 at 5:25 PM Akshay Joshi wrote: > Thanks, the patch applied. > > On Wed, Dec 1, 2021 at 4:23 PM Pradip Parkale < > pradip.parkale@enterprisedb.com> wrote: > >> Hi Hackers, >> >> Please find the attached for #7031 Database definition wrong. >> >> -- >> Thanks & Regards, >> Pradip Parkale >> Software Engineer | EnterpriseDB Corporation >> > > > -- > *Thanks & Regards* > *Akshay Joshi* > *pgAdmin Hacker | Principal Software Architect* > *EDB Postgres * > > *Mobile: +91 976-788-8246* > -- Thanks, Aditya Toshniwal pgAdmin Hacker | Software Architect | *edbpostgres.com* "Don't Complain about Heat, Plant a TREE" --000000000000210e2405d214c92e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Pradip,

You did not include the server_old table for qu= ery_history. Please also remove the commented code:
+=C2=A0=C2=A0=C2=A0=C2=A0#=C2=A0db.engine.execute("PRAGMA=C2=A0fo= reign_keys=3DON")
+
+=C2=A0=C2=A0=C2=A0=C2=A0#=C2=A0db.session.commit()
=
+
+=C2=A0=C2= =A0=C2=A0=C2=A0#=C2=A0db.engine.execute("PRAGMA=C2=A0foreign_keys=3DON= ")
+
= =C2=A0


On Wed, Dec 1, 2021 = at 5:25 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Thanks, the patch applied= .

On Wed, Dec 1, 2021 at 4:23 PM Pradip Parkale <pradip.parkale@enterprisedb.co= m> wrote:
Hi Hackers,

Please find the attached f= or #7031 Database definition wrong.

--
=
Thanks &a= mp; Regards,
Pradip Parkale
Sof= tware Engineer | EnterpriseDB Corporation


--
Thank= s & Regards
Akshay Joshi
pgAdmin Hacker | Principal Softw= are Architect
EDB Po= stgres
Mobile: +91 976-788-8246



--
Thanks,
Aditya Toshniwal
pgAdmin Hacker=C2=A0| Software A= rchitect=C2=A0| edbpostgres.com
"Don't Complain about Heat, Plant a TREE&qu= ot;
--000000000000210e2405d214c92e--