Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 9C9CB1DCB2B1 for ; Mon, 27 Feb 2012 15:19:36 -0400 (AST) Received: from acidenitrix.villemain.org ([91.121.90.165]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S266f-00063e-Nq for pgsql-hackers@postgresql.org; Mon, 27 Feb 2012 19:19:35 +0000 Received: from 89-158-241-83.rev.dartybox.com ([89.158.241.83] helo=DimIMac.local) by acidenitrix.villemain.org with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69) (envelope-from ) id 1S266Q-00022N-UW; Mon, 27 Feb 2012 20:19:18 +0100 Received: by DimIMac.local (Postfix, from userid 501) id 348663BAA6BF; Mon, 27 Feb 2012 20:19:13 +0100 (CET) From: Dimitri Fontaine To: Thom Brown Cc: Dimitri Fontaine , PostgreSQL Hackers Subject: Re: Command Triggers, patch v11 Organization: 2ndQuadrant References: User-Mail-Address: dimitri@2ndQuadrant.fr Date: Mon, 27 Feb 2012 20:19:13 +0100 In-Reply-To: (Thom Brown's message of "Sat, 25 Feb 2012 12:42:00 +0000") Message-ID: User-Agent: Gnus/5.110018 (No Gnus v0.18) Emacs/24.0.93 (darwin) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201202/1325 X-Sequence-Number: 203689 Thom Brown writes: > test=3D# CREATE TABLE badname AS SELECT 1::int id, 1::int a, ''::text b; > SELECT 1 > > This doesn't even get picked up by ANY COMMAND. You won't believe it: CTAS is not implemented as a DDL. Andres did some work about that and sent a patch that received positive reviews by both Tom and Robert, once that's in I can easily add support for the command. Thanks Andres=C2=A0:) -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support