Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bk706-0001Eh-OA for pgadmin-hackers@arkaria.postgresql.org; Wed, 14 Sep 2016 10:01:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bk705-0005kA-Mf for pgadmin-hackers@arkaria.postgresql.org; Wed, 14 Sep 2016 10:01:05 +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 1bk6zs-0005Vn-KW for pgadmin-hackers@postgresql.org; Wed, 14 Sep 2016 10:00:52 +0000 Received: from mail-it0-x230.google.com ([2607:f8b0:4001:c0b::230]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bk6zm-0003bK-JV for pgadmin-hackers@postgresql.org; Wed, 14 Sep 2016 10:00:51 +0000 Received: by mail-it0-x230.google.com with SMTP id 186so15899534itf.0 for ; Wed, 14 Sep 2016 03:00:46 -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=rQPNsAnktFDsK6ENnNMVEfT0ebXza/XDHi/G+LHyGfU=; b=Vy8RXyQ1pnW07oD8O9LesTNdFNjjY+Q1vbVeWOKwLMhcftRgPkf9V2VEe/4R20UsJ9 yz8eO85vG83j+3oiWR9JBS3Uw2BVATTiw7pbABBMIA4moR0fy5r4LfqMlruOB0squNzY lZ9zuG4Hyyx5zv37cy9zcE3Oi6Wgo1rO7ILuriilbiHFZEL/2SvubEcJLikmZ9be8dPF k5fw8XsrWHBT74mqnjqd+jL8VQsGY3S0RDGsxImQp7gptyreyCpdSWxWMzjPLmVbBIR0 9hECHynEnTH31HheBjPvhjeJqmHk89Tbcs/RpDKiVMuJa1iT/cZfSDQvKAia3GyUnEJ7 jIhg== 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=rQPNsAnktFDsK6ENnNMVEfT0ebXza/XDHi/G+LHyGfU=; b=mzoXXH/j/FHGv/4DlPTXCXK2DCj+Mq9qXlws6JsJl6Zz1mzX1VlHByTm5JKcnn/cVZ DAvD//3sMBwtLUP5Szl5WLNcvAlwTtd7ELgFWfns0rarb4zHRTrnPx1p3ThqNxe6N9BC M0fsBhchxtRJdNnpoffK1fHtO5X96z6Tr0SQCp8VLW8asY0zQ+MzEwrlq6PUrC/xZUYr J73rZQvFTaYwfE9ni4H/srSvJqK7NFIoCj3Hj0TzT6uQNanrUmAj8gf19BUsgKJF/LNQ s8VHJ9ZGIgmhEgap5OmNRfoV7P++ZVCeWmhE2Q4jkQfJ/X/qUUq6P+/CH9Z/olSZ3eiS p/RQ== X-Gm-Message-State: AE9vXwO9bQIZR07/S2WvCqz9PQZzr6JlYcomwPlG9wtF4iIW2LD/c9k0MO9c73yXQjOB9LzU0P+CW2cpKIc5jg== X-Received: by 10.107.151.11 with SMTP id z11mr5080691iod.28.1473847245777; Wed, 14 Sep 2016 03:00:45 -0700 (PDT) MIME-Version: 1.0 Received: by 10.64.1.203 with HTTP; Wed, 14 Sep 2016 03:00:45 -0700 (PDT) In-Reply-To: References: From: Dave Page Date: Wed, 14 Sep 2016 11:00:45 +0100 Message-ID: Subject: Re: [pgAdmin4][Patch]: RM1674 - Reverse engineered SQL for functions with default values is incorrect 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 - committed with a couple of minor formatting tweaks: - Remove the leading space before arguments (e.g. s/, /\r\t/ instead of s/,/\r\t/) - Put the first argument on a new line as well. Please double-check I didn't break anything that I've missed! On Tue, Sep 13, 2016 at 12:41 PM, Surinder Kumar wrote: > Hi > > Patch with following changes: > > 1) In SQL pane, the signature in comments had arguments with name and type, > Now it will show arguments with type only. > > 2) There is no indent+newline between arguments (there isn't even a space). > - Fixed > > 3) The default value for the last argument is omitted. - Fixed > Last argument is omitted because the value for the last argument we got from > table is empty. > Now we form function signature in the get_definition.sql using > 'pg_catalog.pg_get_function_arguments' method. > > Above changes will reflect in Functions, Procedures & Trigger function > Nodes. > > Please review attached patch. > > 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