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 1jM4yE-0000y3-AR for pgadmin-hackers@arkaria.postgresql.org; Wed, 08 Apr 2020 07:17:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jM4yD-0006XC-7V for pgadmin-hackers@arkaria.postgresql.org; Wed, 08 Apr 2020 07:17:57 +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 1jM4yD-0006X5-1n for pgadmin-hackers@lists.postgresql.org; Wed, 08 Apr 2020 07:17:57 +0000 Received: from mail-lf1-x134.google.com ([2a00:1450:4864:20::134]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jM4yA-0006FA-KI for pgadmin-hackers@postgresql.org; Wed, 08 Apr 2020 07:17:56 +0000 Received: by mail-lf1-x134.google.com with SMTP id m2so4333693lfo.6 for ; Wed, 08 Apr 2020 00:17:54 -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=6HHCBwhzCaJhPt75riscnw87zT0sDuqk/mE17vV7lyY=; b=CmmI01VfAhmF0aqWNB+2eIMEl3By+xRF41U8wueVNMvEbeorT339WcfEcVmMKi7Qqt TJIsjVqiLkbz4diUOVSapXpsyGA/8afnAqrzX2k8xJpfYxdfO5eeKxrxiKGMOOpSRDcv 6iA57zFuKHMXZGBA6en/az20IEwyJllnbe+k/FjA4AKBsbENbYKL08IpDNNhnUXgVYHb cwLwXfaELsK3dfmX3yrx2bKOgKt9OHkJHqCBSKGk3ZAp78gH/hs4SqUdvObnWG2UpZlR GYFFbQOTW7hQuzEVBbOkYmtZ4wgmadZtLPpsieVpTc0WEMh9xvCniPuEZed52ctruJCx cO+Q== 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=6HHCBwhzCaJhPt75riscnw87zT0sDuqk/mE17vV7lyY=; b=OtSLJYGDdHcMqmM66vEaRuaBNJ6WxGKofzLLQ299fZmdRKlUaoPDpf5ejTnkDXv1h4 I5lGq0cZE6awoBhPbhJeusc4RDDxjO6mLEq3CZyWsLnEiqiTpQ4imQtwFB7ntxF/DrxL wRHMLXNwi3PoMRUfmr6e7wg7yDPseNWbOnALspNy1SL0+WcsBNCXqUDqS3R3SwwGbpS0 skItUIm2zzB52B8ahAfV06+QhUkmHXGYFXSST+o2WFfuEZNya1dUTfHpZKSsibRzL37N oyJZtaN3ob98dJ8PIT9OiXuOTPes47O+ZSYfAE6T9w4pMQfy/AvOftRP98UFQ3eXuXpv UuQg== X-Gm-Message-State: AGi0PuYFoHpnprvcRGaK6URCnCnlUCfgLMOkc6kcFGuszYL3Ls2C7lRO dtf2ioc29iky63ZghXxgb96A+rKzNp4Fys9kYwejviFmEejP+eG8Pb26A1hfMvkDCpUKlTzCw94 0VEjovPaU05EffdjwE32MuQQ8v3SfdvUTrsavMN/+F+/6XOYiVnI8kcoScWJJ/gjtROpckH8qNl ZeNmf0Efeyp5W3UYzRrsMbO57C4TOmSFFC/3FtX3Z+Vlax9nlFuh8= X-Google-Smtp-Source: APiQypL0wOjptCJ0JdKiGIueZceLc5DSkrEwGyWtcMny0aa6FQ+/pKyCTGNQK9UV4hGB/oAms3M5oP0Vh24Zr5aD4ek= X-Received: by 2002:ac2:4199:: with SMTP id z25mr3712139lfh.90.1586330272086; Wed, 08 Apr 2020 00:17:52 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Khushboo Vashi Date: Wed, 8 Apr 2020 12:47:45 +0530 Message-ID: Subject: Re: [pgAdmin4][Patch] - RM 5270 - [EPAS] Synonym properties does not show OID. To: Ashesh Vashi Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="0000000000005d4f2605a2c24c6d" X-CLOUD-SEC-AV-Info: edb,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: Precedence: bulk --0000000000005d4f2605a2c24c6d Content-Type: text/plain; charset="UTF-8" On Wed, Apr 8, 2020 at 12:40 PM Ashesh Vashi wrote: > On Tue, Apr 7, 2020 at 6:37 PM Khushboo Vashi < > khushboo.vashi@enterprisedb.com> wrote: > >> Hi, >> >> Please find the attached patch to fix the RM # 5270 - [EPAS] Synonym >> properties does not show OID. >> >> As per the current implementation, we completely ignored OID and instead >> considered the name as the unique field, now with this patch OID will be >> used as an unique id and also will display OID in the properties tab. >> > Question is: When we rename a synonym, does it create a new OID, or keep > the same? > > We can not rename a synonym, must drop it and recreate it. > -- Ashesh > >> >> Thanks, >> Khushboo >> >> --0000000000005d4f2605a2c24c6d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Wed, Apr 8, 2020 at 12:40 PM Ashes= h Vashi <ashesh.vashi@e= nterprisedb.com> wrote:
On Tue, Apr 7, 2020 at 6:3= 7 PM Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:
<= div class=3D"gmail_quote">
Hi,

Please find the a= ttached patch to fix the RM # 5270 -=C2=A0[EPAS] Synonym properties does not show= OID.

As per the current implementation, we completely ignored OID and in= stead considered the name as the unique field, now with this patch OID will= be used as an unique id and also will display OID in the properties tab.
Question is: When we rename a synonym, d= oes it create a new OID, or keep the same?

=
We can not rename a synonym, must drop it and recreate it= .=C2=A0
=C2=A0
-- Ashesh<= /div>

=
Th= anks,
Khushboo

--0000000000005d4f2605a2c24c6d--