Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bReNI-00082J-Ag for pgadmin-hackers@arkaria.postgresql.org; Mon, 25 Jul 2016 11:48:44 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bReNH-0005OZ-Ty for pgadmin-hackers@arkaria.postgresql.org; Mon, 25 Jul 2016 11:48:43 +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 1bReN4-00058C-Li for pgadmin-hackers@postgresql.org; Mon, 25 Jul 2016 11:48:30 +0000 Received: from mail-it0-x22b.google.com ([2607:f8b0:4001:c0b::22b]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bReN1-0005me-0C for pgadmin-hackers@postgresql.org; Mon, 25 Jul 2016 11:48:30 +0000 Received: by mail-it0-x22b.google.com with SMTP id u186so82842652ita.0 for ; Mon, 25 Jul 2016 04:48:26 -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=yfHKd8eU6T4fnVkp1VXAXLj8dT/9qErcXGeHvBajj6w=; b=WyL9Areis+S1G3mnnYm3s9COsCBJHvKfeOnxrrlASSY/73Ckn7oeesUOcZ13D8g5gG kxkyx7dsgWVwz54041gGwA0H2+6RpQXuJV5ggMSFwx1+Gm+LsRAXTYYy5LgA+52H/Fzz HsaKZIRl82LfqBEcTSxWyHpQkrThrDY2/pV6nzSzcGAhTia8EVv21Y7oOGGdBjaMkeX5 dI41nLhM3GlKjMgiap3oVu6xJF9NvDAUB7T1csl3TdGU13sp49hGbdJiSvCDqz0lflkS jeKDxx/QD4WN6M0Rcz/8jQMR5J2x6bH84pR2N7ecVVVwWQGPn2p5IqzAeOqqxDZFXYpf +4gg== 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=yfHKd8eU6T4fnVkp1VXAXLj8dT/9qErcXGeHvBajj6w=; b=CTOf2Vq2LnNwue2wsNVxUfTu7UrOVCvgUZHBFiwpkhuSkE62IfYhPOdzj95u+elnEZ EQYde/puPh4vCSsJSFZ2bMHYHfSQ8bluvy7GQMCaiv9hfu7R+2WbPqSzrZkiVUC1zr15 mOvKDi6owU5kfGr8math99Q2BuJlcowrVardOKgRPKgm0S1U8FZI1gqACQF5i3xt+FCe AezQfSPSTM+y+hhhrUQrWaf6o6dSkKrzG5v83sG26i+vRSmhIjYDsfOM7/mmqPV/5bCJ WFI6ck00QVZJl8fk3aE/er6EcYZ0mNy2SZWaKEiTYjL/nJUqJ07rBnJqTua5G0ZnXhGc 9miA== X-Gm-Message-State: AEkoousnoB5Zrvqp0Gm8fyM9i1bsuHuIfQ0wswDA4B6jVPjmni659mQx6xdsWv66i+dRcPkPRTThnAW7nmBGnw== X-Received: by 10.36.16.197 with SMTP id 188mr19975850ity.88.1469447305316; Mon, 25 Jul 2016 04:48:25 -0700 (PDT) MIME-Version: 1.0 Received: by 10.64.208.97 with HTTP; Mon, 25 Jul 2016 04:48:24 -0700 (PDT) In-Reply-To: References: From: Dave Page Date: Mon, 25 Jul 2016 12:48:24 +0100 Message-ID: Subject: Re: [pgAdmin4][patch]: Fix for RM 1320 To: Neel Patel 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 Mon, Jul 25, 2016 at 7:01 AM, Neel Patel wrote: > Adding more details. > > Root cause:- > > When user change schema of already created fdw extension then while creating > the new fdw we should append the .. > Previously we added only so while executing the query it > will not be able to find fdw handler name without schema name. > > e.g. If user changed the fdw handler 'postgres_fdw_handler' under schema > 'test' then we should display the handler name under fdw as "test. > postgres_fdw_handler". > > Solution:- > > With this patch, we have added . so while > creating or updating the fdw, proper sql will be generated. > > Thanks, > Neel Patel > > > On Mon, Jul 25, 2016 at 11:02 AM, Neel Patel > wrote: >> >> Hi, >> >> Please find attached patch file for the fix of RM- 1320. >> >> RM-1320 - Unable to create foreign data wrapper when user change the >> schema of extension 'postgres_fdw_handler'. >> >> Thanks, >> Neel Patel > > -- 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