Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ao5wv-0004vk-Jz for pgadmin-hackers@arkaria.postgresql.org; Thu, 07 Apr 2016 09:10:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ao5wu-0005KR-I8 for pgadmin-hackers@arkaria.postgresql.org; Thu, 07 Apr 2016 09:10:00 +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 1ao5wu-0005KH-2q for pgadmin-hackers@postgresql.org; Thu, 07 Apr 2016 09:10:00 +0000 Received: from mail-ig0-x231.google.com ([2607:f8b0:4001:c05::231]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1ao5wq-0004Bs-Au for pgadmin-hackers@postgresql.org; Thu, 07 Apr 2016 09:09:59 +0000 Received: by mail-ig0-x231.google.com with SMTP id kb1so9111885igb.0 for ; Thu, 07 Apr 2016 02:09:56 -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:date:message-id:subject:from:to :cc; bh=o0gWnedwWQCqk/BCnmklO51gyZyKkUf6217slmdoRDw=; b=yAYqUjDol04QcQG8PK7tpIP8Woka7LY2kwKO/klv80uWKd6laDFDe2pTPix4CtXfCf yb9YfWLvZalCgmUWBi8XqKmhFFWkIzlFSne4Sce88TLNH+ZzpLHGKihAvxcsc87AZN+g 68bf7M/KtSX5W7PdUo1B037y7cwBzm3QD4xq/+t2YRI4sksm82VWkoJRKdN9Bww4HQ5n cTS8qfI0lR8ioB6uuu5Pn6fRVaHgdWYTuiGyt4A6Z7KZDUkyacA3LQ1XpbunRj1cwY8l idUQQQK12N4o+lgES0BG+GWfARsnzE7iwISluLd1u3/OAK+NJRDuLTmk9Tuh6tZKvzzu 4crQ== 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:date :message-id:subject:from:to:cc; bh=o0gWnedwWQCqk/BCnmklO51gyZyKkUf6217slmdoRDw=; b=F81fbCOSSAGyLAO7ttdugNjrF0bmmyDV0cyfDNxu3glkhiDscWSD7kbce11mkreRDQ 7lSabnqxei8//rrRgQWNcJJ2GAU3wVQh9splZNUgJ7Z6/kUdW28GTxWMPNWMSve6l4TF bLDY4dCa+Sp/9C59pJDfB+ly96l/wER18b1kwwfyWjDjn3QscukKt0V/j5yBMoSaXIy5 x4IMN9m3gTqQ1dd9+OZJ246bOYTjI3Mqx6X2/QQZN9ieZA4PxMCY3loRgrpSwmT2Qt89 m9zSHqZDBZwiM5sLMAXaD0jsiAUzTW6yFlNXgNljhZSafBAocqebArLmSy8TKts7ZASa rcmw== X-Gm-Message-State: AD7BkJJAogYG+mSc7TnLpIXo5fKBztOsi3l/o93mh7E8SVydqvuUfu1VffJUQt4aPxHgiLYLFBpjpPNNqrSQVQ== MIME-Version: 1.0 X-Received: by 10.50.93.138 with SMTP id cu10mr877070igb.96.1460020194515; Thu, 07 Apr 2016 02:09:54 -0700 (PDT) Received: by 10.64.105.131 with HTTP; Thu, 7 Apr 2016 02:09:54 -0700 (PDT) In-Reply-To: References: Date: Thu, 7 Apr 2016 10:09:54 +0100 Message-ID: Subject: Re: PATCH: PGADMIN 4 - FTS templates node From: Dave Page To: Sanket Mehta 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 Hi On Mon, Mar 28, 2016 at 10:01 AM, Sanket Mehta wrote: > Hi Dave, > > I have found out the root cause of this issue. > > This issue is occurring at your side as you are using python 2.7 so in that > case sql query returned from sql template is of type 'unicode'. > And in __init__.py file we have checked if the sql query is of string type > then only we would proceed further. > > I was not getting this issue as I was using python 3.0 > > I have resolved this issue and some other typo errors in comments and patch > is attached with this mail. > > Please do review it and let me know in case of any issues. Did you send the right patch? I'm still getting the error (specifically, when rendering update.sql, render_template throws an exception "can't adapt type 'Undefined'") -- 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