Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bkuKe-00051Y-Ba for pgadmin-hackers@arkaria.postgresql.org; Fri, 16 Sep 2016 14:41:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bkuKd-0005Hl-UH for pgadmin-hackers@arkaria.postgresql.org; Fri, 16 Sep 2016 14:41:35 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bkuKQ-0004v4-EN for pgadmin-hackers@postgresql.org; Fri, 16 Sep 2016 14:41:22 +0000 Received: from mail-io0-x236.google.com ([2607:f8b0:4001:c06::236]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bkuKN-0006V1-HC for pgadmin-hackers@postgresql.org; Fri, 16 Sep 2016 14:41:21 +0000 Received: by mail-io0-x236.google.com with SMTP id m79so27806815ioo.3 for ; Fri, 16 Sep 2016 07:41:19 -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=YPjN9dmMwE58uvnTCae/V+fV4KVWSQiMl/3PQxg0sO4=; b=KX31Ga2QKuGNbIRrazt/2+2x5hCR1IhDGcHD+tc6HyiqezkAbLHMOm7kZpvYdTCgmu kTvk51ZQJEnivWoDI389T7fujnzaMEm6jV/ciEFTT6dJSHGjHE8YX5cHrtknvg8Aq1l3 K/uKj01bswGtRaVx3kPgJCg53Jtqc3huxxVf/p7WHYiv33Y9Fu6Hegj2htWJXVkNvbfL B5+jf9+c//t9wqBbFCFV4A1O34+JktPkZ7WavxdnaQT3AccmGy2BA2NIpxdMaYDEqV7/ j7MqiX/GyskgtFU8xb2zEbPxgJasl6NYzcw888HWU2JWHaU/Ve1TnENubx+qMoSCs4n/ 4Unw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=YPjN9dmMwE58uvnTCae/V+fV4KVWSQiMl/3PQxg0sO4=; b=VD7BOnSJ+jhnWxCYr3Dy3Nnv0BgCUJV6krLOc4cU833jM4sZcx41/kcMEaypR2btM+ gsfCwiFdTHPqpm4eo2hS40HL3h5jgzl9vSPZAOAJOmdv/21a+wvkK29QGC14PfFVBryU K7lbkteaaoHB3jSiRDzRsEhDrMTi62NefmgOc/PenX0r/LAV99l1YK+sw2ufbjHMoSEl y+62HtnfuoshbO976Mzyp0rVfw3XFEGSeG2WSNcIYn4iPARKlzHFZNnp/SjWrU8bRukk b4Lljr+lVo8F0plbG8BKr5EhropicKFexNc7JbKKZhw7zTUAcsLVNM09rDtS0T4lmmCZ 8DuQ== X-Gm-Message-State: AE9vXwNRg3OUdo69EPwj940pv2f+mmbxX6ZSx0NZWP/jfwvQSso2wKQJ2dGuKVsf/IrwLwD6JePkqInNIMBvyw== X-Received: by 10.107.48.18 with SMTP id w18mr15445685iow.147.1474036878546; Fri, 16 Sep 2016 07:41:18 -0700 (PDT) MIME-Version: 1.0 Received: by 10.64.1.203 with HTTP; Fri, 16 Sep 2016 07:41:17 -0700 (PDT) In-Reply-To: References: From: Dave Page Date: Fri, 16 Sep 2016 15:41:17 +0100 Message-ID: Subject: Re: [pgAdmin4][Patch]: RM1595 - "no results to fetch error" displayed if modify definition with other table To: Surinder Kumar 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, applied. On Fri, Sep 16, 2016 at 11:14 AM, Surinder Kumar wrote: > Hi > > Issues fixed: > > 1) Creating a m-view with definition and then updating view with new > definition, it results into an error "No results to fetch". > > 2) When definition of m-view is updated, it creates a new m-view with > different OID, but it wasn't updating the old OID with new OID of tree node > in tree view. thus on switching to another tab (e.g.: sql), it throws > message "Cannot find materialized view". > > Please find attached patch and review. > > Thanks, > Surinder Kumar > > > -- > 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