Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gaULi-0000Z2-Ho for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Dec 2018 23:36:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gaULh-0001Iw-8R for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Dec 2018 23:36:57 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1gaULh-0001Io-11 for pgsql-hackers@lists.postgresql.org; Fri, 21 Dec 2018 23:36:57 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gaULe-00089j-UB for pgsql-hackers@postgresql.org; Fri, 21 Dec 2018 23:36:56 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id B012FB1E; Fri, 21 Dec 2018 18:36:52 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Fri, 21 Dec 2018 18:36:52 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=p2zh1ujkNZzMhi4+L6GsR8V6zlk ufaq9+i0B5bL5XNU=; b=IUyFWYKKzd7VPkB4D9WyTxV3d8KoF0B+HGV5PJJxV1V 9St5Y5W/a3rRDajVj5t445o+4a7xnJURRIKxsz2DTHps849UV9uCAqeP5iO4oFaE 1781vpqfVu1sMZg356TAQmpJGwUcRy8qKcgs8h8TrKQ7hCXK+Xc5WK2cwA4Bk4oN N6Q0nFjtSsEln99GGu/Jsv9hCGRJ0BW5jX9ttvS2Wv4N/rQg9cEZpnlboGywGFZC x2LJtTsGK4ciZUSXIj/pt+ytwcl9emMTkc3OzVSx1xVGkwTD/Gt29dUaBblS+Yj5 8HJwhroP60OrMN148IXaiPFBkn3tE+hQsIaOdcl0wkg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=p2zh1u jkNZzMhi4+L6GsR8V6zlkufaq9+i0B5bL5XNU=; b=DpJ0UA8ops8BIKQgK65zEt 7EnfXHIclt1wHX55OGv540Xi62oDpf7XdBoWR6u1o25FMudjQonQo+B3t3LWDpn/ CeCQMwIb20bh2/k6URAuOTd4mAllg4GPUpInHVWu8i/x7qnr/3OqtTeUvLy03NPS Etrpznro49wuP1Qyiynwi7UcmdgZYKMuxy1dz0Jpd1k9w2Fs/WvuxKk+noNmgNSf jUUCwRZSJfOgEa6CbBAsH4SwPVhVt4E53bJpBVII2YlmzrRRj4R5E1lQJvWdde99 P+c5awxpQSW8B5nyW6isSWXxv7zhr2NAPL+zGM9snckhyZdGNAJYmnHYE9SPtkOg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtkedrudejiedgudefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfquhhtnecuuegrihhlohhuthemucef tddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfghrlhcuvffnffculdejtd dmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddunecuhfhrohhmpefoihgt hhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqne cukfhppeeiuddrvdduhedrudefjedrudeivdenucfrrghrrghmpehmrghilhhfrhhomhep mhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlhhushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 39C95100BA; Fri, 21 Dec 2018 18:36:49 -0500 (EST) Date: Sat, 22 Dec 2018 08:36:47 +0900 From: Michael Paquier To: Dagfinn Ilmari =?iso-8859-1?Q?Manns=E5ker?= Cc: pgsql-hackers@postgresql.org Subject: Re: [PATCH] Improve tab completion for CREATE TABLE Message-ID: <20181221233647.GD1948@paquier.xyz> References: <20181219050530.GC19856@paquier.xyz> <20181219234408.GD27104@paquier.xyz> <20181220053352.GO27104@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="yudcn1FV7Hsu/q59" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --yudcn1FV7Hsu/q59 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Dec 21, 2018 at 01:57:40PM +0000, Dagfinn Ilmari Manns=E5ker wrote: > Yeah, because of that we can't do the obvious HeadMatches("CREATE", > "TABLE") && (TailMatches(...) || TailMatches(...) || ...). I believe > this would require extending the match syntax with regex-like grouping, > alternation and repetition operators, which I'm not volunteering to > do. That seems to be a lot of work for little benefit as few queries are able to work within CREATE SCHEMA, so I would not take this road. -- Michael --yudcn1FV7Hsu/q59 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlwdeQ8ACgkQnvQgOdby QH1pPw//R/UKUToY2nMZM4Pd4C9liDm71CB9NIs7Hp1wfIyj5PCYwdJUZugArMPg V7tW8FGtrEQhNf5LXyvI2N8QFknfgknm0xdi47W2A3tWj8PLw08+NCGd9TpTlcCV 4eW/gV0+bDlop3c2hXpcmD1sD1hCWgeF04b7GVOSle7kE5/C77uotphqiofPSWAi kRnohfxbq7aKg8NteESn4pR/cJtd3y8uto/m5lX86D9spB2D7Fm63TO2n+QS/jMR FoJcBysI0+Qs0Jqlom67RanE7otZY7dPIDGs/9UYFDTTjuVox0pifTSo2B/y2I1x brBVpN+kulWg0h+J8LbA0l0sw+OyKV4u/xzu0O5KOFgNzRsHmYS6SMSTGVdSYGjD 0BtcsQPdRS8WGD8lJiZWgIlo4ZALzafY9cnTVhetbjRKpjh3o8SzvmH14UgJEFSx nCspqFVILaz6Q+7/C5RJh7qKgm2chwWNm+gpIng/LysTKLRe/SvIWz0zzga8bt4A bHqplJngexdocutxm7J5JL1Q/BIpAX7X6VC4fIZ+XIGb4LW1Ra07+Xh3VtmBg5Be Is4u1njcQfYzXbgdHh9hAJxbFXk9E4d7WXIFXPp1ahip5AzqSJUmwpXiyohrvxEN O/UPMS/4nGxMiYp8KFm0TpeKtzaUT9MF2/GT0f7KRfrUfAfq8x0= =SNfI -----END PGP SIGNATURE----- --yudcn1FV7Hsu/q59--