Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cafvh-0003lK-9U for pgadmin-hackers@arkaria.postgresql.org; Mon, 06 Feb 2017 09:49:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cafvg-0007kX-4T for pgadmin-hackers@arkaria.postgresql.org; Mon, 06 Feb 2017 09:49:48 +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 1cafvS-0007Vm-G6 for pgadmin-hackers@postgresql.org; Mon, 06 Feb 2017 09:49:34 +0000 Received: from mail-io0-x22a.google.com ([2607:f8b0:4001:c06::22a]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cafvP-00026g-57 for pgadmin-hackers@postgresql.org; Mon, 06 Feb 2017 09:49:33 +0000 Received: by mail-io0-x22a.google.com with SMTP id l66so61651464ioi.1 for ; Mon, 06 Feb 2017 01:49:31 -0800 (PST) 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=NBDygvVYqkFCaEMW94jo/Hf/rOsfBqG4rDia20z5v4c=; b=ZCkENJAIrCiHtECJ+zIU/Qzx2xwY1fKqYTQu3VShrRmHhJz0TFmAWqcT3Q68OzarZP WhwcsL0kJhf4ZhosChSXowC3SKyjDGZ+gIQEtHYRt97G7P0epW/Oc1ty2OsUrDLBZ5wM mo61M6gPUiLCs2L2obWtMprIHsO9v69ZRMwPDH7ORounv86csAVija2W5E/Qgt9mOJwq FgC8VNiDvpbyqAOgs0Ss7JrDBI5yObkTJGhGZ9JLyRZdSWC+ocslcXfKVZl+iWLAyiGs XX2R6E0Dt1DhdnY6XGX9T7maNCvB9oCkj1vcePc1lrHn4+JuJJv/20dAjMo3Tjtd3hlm tVKw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=NBDygvVYqkFCaEMW94jo/Hf/rOsfBqG4rDia20z5v4c=; b=sEQsFpm0srtab/DPnUxstvWhaRV0SEyyDXbEL9CxaZLPSmi9npXZjcZT0fmbbXKmQZ 487l8QxsZMpaMD5N1Dae1LAbJioCNNB1h43aI2WMk2x3qhgd/6KQwRwR51J5yTKIqeUL fMUFB6LJ5PhhCzpGpPcAmx6WKjGi3I2lCwUnS6DDuoPvWn12+n+WQHQ/+TxHuNOsOtvj 1XYMVWRv3NNrv1EWvcLcHdTfSXSYlOJ9oA+3Yk1i3RlVsG0hrWH4Y8nCZGaoiD2Ygjre Urn6fjfQJBh/aZrj4lNSpLx8YpmqYsohwI9Z6tBD1YbGZu0IQ9RudvU9Pbpws+6hClf1 S9ZA== X-Gm-Message-State: AMke39lIXHDrUovlSXQ8mdLJCG9iyaH1KZTQa0ERrOxlsOtSgxBiwrXj7d88z3eA1a6rCvMfBF61i20R/StwUg== X-Received: by 10.107.57.5 with SMTP id g5mr5828986ioa.208.1486374569528; Mon, 06 Feb 2017 01:49:29 -0800 (PST) MIME-Version: 1.0 Received: by 10.64.224.198 with HTTP; Mon, 6 Feb 2017 01:49:28 -0800 (PST) In-Reply-To: References: From: Dave Page Date: Mon, 6 Feb 2017 09:49:28 +0000 Message-ID: Subject: Re: [pgAdmin4][PATCH] To fix the issue in handling of timestamp type To: Murtuza Zabuawala Cc: pgadmin-hackers , Ashesh Vashi 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, Feb 6, 2017 at 6:12 AM, Murtuza Zabuawala wrote: > Hi Dave, > > Please find a fix for the same, attribute length was set to False instead of > None. > > > -- > Regards, > Murtuza Zabuawala > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > On Mon, Feb 6, 2017 at 11:18 AM, Murtuza Zabuawala > wrote: >> >> Sure, Checking. >> >> -- >> Regards, >> Murtuza Zabuawala >> EnterpriseDB: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company >> >> On Sat, Feb 4, 2017 at 7:34 PM, Dave Page wrote: >>> >>> Hi Murtuza, >>> >>> I clearly neglected to run the regression tests with this patch, and >>> unfortunately it looks like it broke them. Can you look at this ASAP >>> please? >>> >>> runTest >>> (pgadmin.browser.server_groups.servers.databases.schemas.tables.column.tests.test_column_add.ColumnAddTestCase) >>> This function will add column under table node. (Add table Node URL) >>> ... 2017-02-04 14:43:55,191: ERROR pgadmin: Failed to execute query >>> (execute_scalar) for the server #4 - DB:test_db_9e176 (Query-id: >>> 4792242): >>> Error Message:ERROR: syntax error at or near "False" >>> LINE 2: ADD COLUMN test_column_add_f0d5d char(False); >>> ^ >>> FAIL >>> >>> As far as I can see, the app works fine - it's only the test that >>> broke (probably because the application uses type name aliases (e.g. >>> character) rather than the base type name that the test is using >>> ("char"). >>> >>> Thanks. >>> >>> On Fri, Feb 3, 2017 at 1:52 PM, Dave Page wrote: >>> > Thanks - patch applied. >>> > >>> > On Fri, Feb 3, 2017 at 11:46 AM, Murtuza Zabuawala >>> > wrote: >>> >> Hi, >>> >> >>> >> Please find updates patch for the same. >>> >> RM#2076 >>> >> >>> >> -- >>> >> Regards, >>> >> Murtuza Zabuawala >>> >> EnterpriseDB: http://www.enterprisedb.com >>> >> The Enterprise PostgreSQL Company >>> >> >>> >> On Wed, Feb 1, 2017 at 3:08 PM, Dave Page wrote: >>> >>> >>> >>> Hi >>> >>> >>> >>> On Tue, Jan 31, 2017 at 5:19 AM, Murtuza Zabuawala >>> >>> wrote: >>> >>> > Hi Dave, >>> >>> > >>> >>> > PFA updated patch. >>> >>> >>> >>> This seems to display "timestamp(0) with[out] timezone" columns >>> >>> correctly in both the properties panel and dialog now, but the size >>> >>> is >>> >>> still ignored if I try to add a new column through the table or >>> >>> column >>> >>> dialogue. >>> >>> >>> >>> -- >>> >>> Dave Page >>> >>> Blog: http://pgsnake.blogspot.com >>> >>> Twitter: @pgsnake >>> >>> >>> >>> EnterpriseDB UK: http://www.enterprisedb.com >>> >>> The Enterprise PostgreSQL Company >>> >> >>> >> >>> > >>> > >>> > >>> > -- >>> > Dave Page >>> > Blog: http://pgsnake.blogspot.com >>> > Twitter: @pgsnake >>> > >>> > EnterpriseDB UK: http://www.enterprisedb.com >>> > The Enterprise PostgreSQL Company >>> >>> >>> >>> -- >>> Dave Page >>> Blog: http://pgsnake.blogspot.com >>> Twitter: @pgsnake >>> >>> EnterpriseDB UK: http://www.enterprisedb.com >>> The Enterprise PostgreSQL Company >> >> > -- 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