Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aEMgI-000123-HU for pgadmin-hackers@arkaria.postgresql.org; Wed, 30 Dec 2015 19:45:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aEMgH-00089w-U3 for pgadmin-hackers@arkaria.postgresql.org; Wed, 30 Dec 2015 19:45:09 +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) (envelope-from ) id 1aEMg4-0007uN-98 for pgadmin-hackers@postgresql.org; Wed, 30 Dec 2015 19:44:56 +0000 Received: from smtp40.i.mail.ru ([94.100.177.100]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1aEMfw-0003bL-93 for pgadmin-hackers@postgresql.org; Wed, 30 Dec 2015 19:44:55 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=bk.ru; s=mail; h=Content-Transfer-Encoding:Content-Type:In-Reply-To:MIME-Version:Date:Message-ID:To:Cc:From:References:Subject; bh=P2Zabn6AhE+4IqiKm7mcywjV2L6KC2SDAseVpMRNQlg=; b=fQGNQ7usokgZRoBDCrrF2s5w5udhSCFOgBsUw/w6q92Sbh7jd/vwjgOEBHexlMRKmYKuMeL0g0tRWi41B3WrwNCqUFt1jcm+0RCsclp536YqjOnFeAJ5jJ1jERkORA07yQW+b8rVK6n3ihyi1BD4REXtMLl/dYzmVImUBccnD1Q=; Received: from 22.37.117.87.donpac.ru ([87.117.37.22]:62452 helo=[10.6.197.94]) by smtp40.i.mail.ru with esmtpa (envelope-from ) id 1aEMfu-00008h-A4; Wed, 30 Dec 2015 22:44:46 +0300 Subject: Re: patch: fix to use ``pg_get_functiondef()`` References: <8214ef66e4cf3dc04bd99a0af601e5ab@imp-m.ru> <566D8914.2070507@bk.ru> <4241af2d7143ab303f4d3ad2a5a2dff7@imp-m.ru> From: Dmitriy Olshevskiy Cc: Andrej Antonov To: pgadmin-hackers Message-ID: <56842668.5090906@bk.ru> Date: Wed, 30 Dec 2015 22:46:00 +0400 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101 Thunderbird/38.5.0 MIME-Version: 1.0 In-Reply-To: <4241af2d7143ab303f4d3ad2a5a2dff7@imp-m.ru> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit X-Mras: Ok X-Pg-Spam-Score: -2.7 (--) 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 Hello, dear colleagues) Could you please review this patch (see the previous letter)? As I remember, there are several similar, but unclosed issues in pgadmin mailing list yet. Really, there is a problem with function's definition and this patch probably could solve it (at least for postgresql 8.4 and higher). What do you think? Thank you. On 18.12.2015 13:22, Andrej Antonov wrote: > small fix ( diff see here: > https://github.com/postgres-impulsm/pgadmin3/commit/72f381aa1964d5630f3ada44768bc562911102e9 > ) > > > if we using ``pg_get_functiondef(func_oid)`` -- > in this case -- no need to write additional > ``ALTER FUNCTION ... = ... ;``. > > > Andrej Antonov писал 2015-12-14 10:51: >> thank you, Dmitriy. I agree -- this-fix should >> works better. >> >> I applyed this-fix to my local-git-branches >> ("REL-1_20_0-impulsm" and >> "fix-to-use-pg_get_functiondef"). works good. >> >> Dmitriy Olshevskiy писал 2015-12-13 18:04: >>> Hi, Andrej! >>> Here is small fix of your patch - can you >>> check it please? >>> I think there must be wxwidgets function >>> IsEmpty() instead of double >>> negation, >>> because type of the variable is wxstring. >>> Also I added the Trim() >>> function before >>> check if function definition is empty or not. >>> >>> On 08.12.2015 11:50, Andrej Antonov wrote: >>> >>>> patch: fix to use ``pg_get_functiondef()`` >>>> [see attachment file] >>>> >>>> it is copy of pull-request >>>> https://github.com/postgres/pgadmin3/pull/12 [1] >>>> >>>> thank you! >>> >>> -- >>> Dmitriy Olshevskiy >>> >>> >>> Links: >>> ------ >>> [1] https://github.com/postgres/pgadmin3/pull/12 > -- Dmitriy Olshevskiy -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers