X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D324E9DCC78 for ; Tue, 21 Mar 2006 23:27:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 29324-10 for ; Tue, 21 Mar 2006 23:27:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 699339DCC3C for ; Tue, 21 Mar 2006 23:27:40 -0400 (AST) Received: (qmail 4385 invoked by uid 500); 22 Mar 2006 03:29:24 -0000 Date: Tue, 21 Mar 2006 21:29:24 -0600 From: Bruno Wolff III To: Tom Lane Cc: Alvaro Herrera , Achilleus Mantzios , Peter Eisentraut , "Eugene E." , pgsql-sql@postgresql.org Subject: Re: have you feel anything when you read this ? Message-ID: <20060322032924.GA2262@wolff.to> Mail-Followup-To: Bruno Wolff III , Tom Lane , Alvaro Herrera , Achilleus Mantzios , Peter Eisentraut , "Eugene E." , pgsql-sql@postgresql.org References: <200603201251.11255.peter_e@gmx.net> <20060320121354.GA12564@surnet.cl> <8488.1142894403@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <8488.1142894403@sss.pgh.pa.us> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.104 required=5 tests=[AWL=0.104] X-Spam-Score: 0.104 X-Spam-Level: X-Archive-Number: 200603/343 X-Sequence-Number: 24689 On Mon, Mar 20, 2006 at 17:40:03 -0500, Tom Lane wrote: > > Indeed. I wonder whether we shouldn't tweak the SQL string literal > parser to reject \000, because AFAICS that isn't going to do anything > useful for any datatype, and it leads to what are at best questionable > results. (bytea's processing of \000 happens somewhere further > downstream, and wouldn't be affected.) I think that makes sense. That character is effectively not allowed in text, so it shouldn't be accepted as input.