Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1agE2H-00037R-Rt for pgadmin-hackers@arkaria.postgresql.org; Wed, 16 Mar 2016 16:11:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1agE2H-000138-ES for pgadmin-hackers@arkaria.postgresql.org; Wed, 16 Mar 2016 16:11:01 +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 1agE2G-00010I-C2 for pgadmin-hackers@postgresql.org; Wed, 16 Mar 2016 16:11:00 +0000 Received: from mail-io0-x22f.google.com ([2607:f8b0:4001:c06::22f]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1agE2D-0002Td-6g for pgadmin-hackers@postgresql.org; Wed, 16 Mar 2016 16:10:59 +0000 Received: by mail-io0-x22f.google.com with SMTP id m184so65136518iof.1 for ; Wed, 16 Mar 2016 09:10: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=L7SkXPYkhgls8f+m2kOiTZI6r81R5gjk+Euh4m75znY=; b=eNYT9oRrrf7DIEwiiTvz5WES0E0JqVYiaCYVQOz6/WCEZQHaTf3CkcC445Ofs+2k98 IFCyLydxQJYtGZlSz3hholSOnipw8uR+tL5OgwUSjF26W5EZ2GuAu9ZmAiKkaUePsm9l RH0RKj/W583yG7mQBGVv4ASJpWyBEpzgJFl9ZaIwk9m1XjgbgG4a41+of/fHtDa4NgSw +3OmEVNYqpR5NgRvsxMGPWHli+hGqsm9opfgs31LyJ1/5CaLTbfKLHHm3PByeDrGfyhL w6pZpkUptASzfZQuqJGQ6hACLKwt/+9TNf+QM3N5IXCRK9jTRV9ke3QWz19USZ9ecmVM Q/rg== 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=L7SkXPYkhgls8f+m2kOiTZI6r81R5gjk+Euh4m75znY=; b=c44y74oBbJPPnOJFiaBa2fJJ2wASqYmQxuq9n1IenvmUilbErselYSlYa2scPd3/8Y PjRqtBZ8l18OLhm80+rrt5/7+DIAV8kTqp4YWfogFTq+P6U/wenDtTjD6OoiHNoCletp YmUbzq33GuiO0rT0KYpeE9k5vm0OaoYf1spuxGxD5SGyKxRNOGcpSl9vtuw9Qsqs96Lf ZRyqHw/oGOG7G7ValjSZSib2SQsUSlX9SBLC05JnuDsLtk+SoUKFWcNdKwpAH/x7JyqL PujnU5Wcjz+CBgV47a/5rUCjrOJ6z+lIgqbUZO8/EGxGOSwuqhKM95qILJCxKsMTRtqb xrPQ== X-Gm-Message-State: AD7BkJKxfkNJLjR/xfneudjR7TcuegnK5txT4gb1UwRKJntR8AMWUImVoMzOjvqHqIc1O741/pG/s6RWo5HFQw== MIME-Version: 1.0 X-Received: by 10.107.43.2 with SMTP id r2mr4672906ior.156.1458144655984; Wed, 16 Mar 2016 09:10:55 -0700 (PDT) Received: by 10.64.213.73 with HTTP; Wed, 16 Mar 2016 09:10:55 -0700 (PDT) In-Reply-To: References: Date: Wed, 16 Mar 2016 16:10:55 +0000 Message-ID: Subject: Re: pgAdmin4 PATCH: Domain Module From: Dave Page To: Khushboo Vashi 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 Wed, Mar 16, 2016 at 2:03 PM, Khushboo Vashi wrote: > Hi, > > Please find the updated Domain Module Patch. > > To test this patch, please apply Backgrid Textarea Cell Patch before this. Thanks. I believe with the following fixes, we'll be done :-) - Default values should be auto-quoted when necessary (ie. strings, on a text-based domain). - "System Domain?" should be in the General section, between owner and comment. - The switches should use the same colouring/styling as other objects, e.g. options: { 'onText': 'Yes', 'offText': 'No', 'onColor': 'success', 'offColor': 'primary', 'size': 'small' } - Please remove the Schema property from the main properties tab (not the properties dialogue). - No icon is show for Checks on the Dependents tab for a domain. - The add button on the Security Labels tab is spelt "Add". Why is that? Other instances of this grid use "ADD" which is the default in backform.pgadmin.js. - Dependencies on domain check constraints are listed as being on a "Type" not a "Domain". - If adding a domain constraint using the grid on the Domain dialogue, I cannot specify "NOT VALID". We need a checkbox for that in a narrow columns at the end. Unchecking it for an existing constraint should be the equivalent of doing "ALTER DOMAIN ... VALIDATE CONSTRAINT" - If I switch the "Don't Validate" switch on a constraint, there are leading blank lines in the generated SQL. The same occurs when adding a comment to a constraint. - I think we need to reverse the meaning of "Don't Validate" and rename to match the "Valid?" field that's on the properties list. Otherwise it's not clear they're the same thing. - s/Not Null/Not Null?/ -- 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