X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 05A943A45CD for ; Thu, 6 Jan 2005 16:45:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16385-03 for ; Thu, 6 Jan 2005 16:45:22 +0000 (GMT) Received: from mail501.nifty.com (mail501.nifty.com [202.248.37.209]) by svr1.postgresql.org (Postfix) with ESMTP id A45583A4547 for ; Thu, 6 Jan 2005 16:45:20 +0000 (GMT) Received: from localhost (ntibrk005135.ibrk.nt.isdn.ppp.infoweb.ne.jp [61.124.27.135])by mail501.nifty.com with ESMTP id j06Givug013233 for ; Fri, 7 Jan 2005 01:44:58 +0900 Date: Fri, 07 Jan 2005 01:44:57 +0900 (JST) Message-Id: <20050107.014457.77038706.fwif0083@mb.infoweb.ne.jp> To: pgsql-docs@postgresql.org Subject: Re: syntax error with example sql of createtable From: Honda Shigehiro In-Reply-To: <20050106.022407.116372061.fwif0083@mb.infoweb.ne.jp> References: <20050106.022407.116372061.fwif0083@mb.infoweb.ne.jp> X-Mailer: Mew version 3.3 on Emacs 21.2 / Mule 5.0 (SAKAKI) Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.516 tagged_above=0 required=5 tests=FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200501/12 X-Sequence-Number: 2771 Hello, Thank you for fixing. I notice that there is also example which cause a syntax error like "create table" in example of below URLs: http://developer.postgresql.org/docs/postgres/sql-release-savepoint.html http://developer.postgresql.org/docs/postgres/sql-savepoint.html A word "table" in SQL "INSERT INTO table VALUES (3);" is reserved. So renaming or quoting are needed to avoid an error. regards, -- Shigehiro Honda