Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1asB3z-0003Rz-Vl for pgsql-hackers@arkaria.postgresql.org; Mon, 18 Apr 2016 15:26:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1asB3z-00044Q-IX for pgsql-hackers@arkaria.postgresql.org; Mon, 18 Apr 2016 15:26:11 +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 1asB3y-00044K-TK for pgsql-hackers@postgresql.org; Mon, 18 Apr 2016 15:26:11 +0000 Received: from newmail.postgrespro.ru ([93.174.131.138] helo=mail.postgrespro.ru) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1asB3v-0007gc-75 for pgsql-hackers@postgresql.org; Mon, 18 Apr 2016 15:26:10 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id B7A2121C7DC6; Mon, 18 Apr 2016 18:26:05 +0300 (MSK) Received: from mail.postgrespro.ru ([127.0.0.1]) by localhost (mail.postgrespro.ru [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id lCvzZyGu_vjO; Mon, 18 Apr 2016 18:26:03 +0300 (MSK) Received: from fujitsu (unknown [192.168.27.1]) by mail.postgrespro.ru (Postfix) with ESMTPSA id BCBEA21C7BC0; Mon, 18 Apr 2016 18:26:03 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1460993163; bh=TlqhX+amXzEt6DNQZxLCDNGGOo38lMmWBlJFOGu/hI0=; h=Date:From:To:Cc:Subject:In-Reply-To:References; b=WVM+mbhaeI5sK8OPxh4/tcQbFUuwEwHdUOvPrDYjxXBaZ8krUJ4l6Yc9o8/e3VlYZ J5j5MdGslFyqLxNnlx8z63JAbMWdVkVMfVPCmxbAb1GizlKrvnDTqkTQGyLu5v+JQb HS88V7t2KG0Wi4x8msa9eOWkmmVLquYQ+rVs5V+c= Date: Mon, 18 Apr 2016 18:25:23 +0300 From: Aleksander Alekseev To: Pavel Stehule Cc: Tom Lane , Arcadiy Ivanov , PostgreSQL Hackers Subject: Re: Parser extensions (maybe for 10?) Message-ID: <20160418182523.3f70ad88@fujitsu> In-Reply-To: References: <570C7B5A.9070309@gmail.com> <5688.1460437831@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -3.0 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org > I cannot to imagine extensible parser based on bison. But the parser > can be replaced by custom parser. > > Some like pgpool or pgbouncer does. The extension can assign own > parser. Custom parser will be called first, and the integrated parser > will be used from extension or as fallback. This can helps with new > statements for background workers, theoretically it can helps with > extending PostgreSQL SQL. Custom parser can do translation from SQL1 > to SQL2 dialect, or can do translation from SQL1 to internal calls. > The custom parser usually should not implement full SQL - only few > statements. > > Is it this idea more workable? What if there are two or more contribs that extend the parser? Can we be sure that these contribs will not conflict? -- Best regards, Aleksander Alekseev http://eax.me/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers