Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dEGo6-0006S3-BF for pgadmin-hackers@arkaria.postgresql.org; Fri, 26 May 2017 15:05:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dEGo5-0006Gd-MD for pgadmin-hackers@arkaria.postgresql.org; Fri, 26 May 2017 15:05:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dEGnq-0005PN-KC for pgadmin-hackers@postgresql.org; Fri, 26 May 2017 15:05:22 +0000 Received: from mail-io0-x232.google.com ([2607:f8b0:4001:c06::232]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dEGnm-00005B-Th for pgadmin-hackers@postgresql.org; Fri, 26 May 2017 15:05:21 +0000 Received: by mail-io0-x232.google.com with SMTP id o12so11026546iod.3 for ; Fri, 26 May 2017 08:05:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin-org.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=eoWHmzdRFGncgu8qHh1x2kh+timSqGlm1FT0l7AC7R8=; b=NRLqK6g1bBhibVGKOpPfPIMSTTqcmuokg1/6VP2iofJ6nVTTxOEz4C0eyUt6UG06xR Cgy0Km4/WAuB4k0kust2phcSYNzxr9/kBr6XUS5rQIzr8FZmPaXRIevLnSTmfyWW8eR2 6PuFm2k0f5TSFiBWFxzKmGym8rxk0EcMW8cApKH32mAuQLIO17dTPye7W30pcLRZp1fJ AFaLTQ/kFpqLjfbk2xZ3pntUFea1bn8uwhRj6Gic2VhxLlgZtxyNzKygzWD/RrostaXX ScRD6JeB4qqpao9XSG30aUEqjtyJ/uvLqLDKtwip7+Bcf6e+4o0kYV/UKXS8iYg+GmJP UH7Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=eoWHmzdRFGncgu8qHh1x2kh+timSqGlm1FT0l7AC7R8=; b=TzE+MHZRKymfmYs1s3ChgWwRO1ySpX6cVjHdEDeXtyzMyD/F2OWr6WR1iU6hfx4I6Z av3mc6+HFg4oP9hf/hTNvEQmN4CHRmJxJm1SCaZ7HRHTKiBCOmKrHU+DgKfaUdpsrMsA e8p9dxXfvXACKyFEj/vX9rIZxhsCwl3DBfOMR7QUoC5In6MNQiJpGjQcZD0aia4caAWo XXZiRouINcMhZESaRur1gg9RhVyXA8HdTqYKLLMgxDrSnkFgLDfPm1+EOd00RMOc2PH+ McUK/2X5jXFFmTd3h3CF1YxdZyF4Y74DqSK3Fwwdv+EsOGUkq/vE2vpfY5eWwoZ1C5lQ 2JxA== X-Gm-Message-State: AODbwcDk7HAil7u9cxXRKzCswY6hUGqNwpoUhMc4ZoFjdallZWQEiuxP 7PUn9wcQFXCbGKkc7gtsKBhKnAhK6ySx2NY= X-Received: by 10.107.3.165 with SMTP id e37mr2255026ioi.232.1495811117193; Fri, 26 May 2017 08:05:17 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.174.147 with HTTP; Fri, 26 May 2017 08:05:16 -0700 (PDT) In-Reply-To: References: From: Dave Page Date: Fri, 26 May 2017 11:05:16 -0400 Message-ID: Subject: Re: [pgAdmin4] [PATCH] To fix issue in UPDATE Script and Primary key order when view data To: Murtuza Zabuawala Cc: pgadmin-hackers Content-Type: text/plain; charset="UTF-8" X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org Thanks, patch applied (and bugs created for the other two issues). On Fri, May 26, 2017 at 6:12 AM, Murtuza Zabuawala wrote: > Hi, > > PFA patch to fix the issue in table node, > 1) In 'UPDATE Script', '?' is missing with last column. > 2) If there are multiple primary keys in table then the order of columns is > incorrect in view data ORDER BY clause. > RM#2417 > > Also fixed minor issue in Materialized view which I found during testing, we > were not passing database id in properties.sql which is required for Select > and Insert script to work. > > -- > Regards, > Murtuza Zabuawala > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > > -- > Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-hackers > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers