X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4521F563CD for ; Mon, 14 Mar 2005 08:51:13 +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 31384-09 for ; Mon, 14 Mar 2005 08:51:05 +0000 (GMT) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by svr1.postgresql.org (Postfix) with ESMTP id F05915612C for ; Mon, 14 Mar 2005 08:51:04 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.201]) by svr4.postgresql.org (Postfix) with ESMTP id C47A75AF958 for ; Mon, 14 Mar 2005 08:51:06 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id j1so1803414rnf for ; Mon, 14 Mar 2005 00:48:57 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=iDnliX/0++2TdlsJv2Uhf50JgtBm8pnNAo48KefD65/poKl+d/5peZDeYfZWPlKrpfV1ke5e0ud5gO/Ro57HsU6YmCdoxxmS9JL32mzR1NZBieQnTT4Gu0INYFkHItzbDh4sDLRnc1m4vn33jOUuCHvPpMO2lhJyNNfR3eHb018= Received: by 10.38.11.1 with SMTP id 1mr1405650rnk; Mon, 14 Mar 2005 00:48:55 -0800 (PST) Received: by 10.38.97.43 with HTTP; Mon, 14 Mar 2005 00:48:55 -0800 (PST) Message-ID: <674d1f8a05031400482c413087@mail.gmail.com> Date: Mon, 14 Mar 2005 14:18:55 +0530 From: Gourish Singbal Reply-To: Gourish Singbal To: Russell Smith Subject: Re: column name is "LIMIT" Cc: pgsql-performance@postgresql.org In-Reply-To: <200503141825.22827.mr-russ@pws.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <674d1f8a0503132314754df153@mail.gmail.com> <200503141825.22827.mr-russ@pws.com.au> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.249 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200503/249 X-Sequence-Number: 10954 Thanks a lot, we might be upgrading to 8.0.1 soon.. till than using double quotes should be fine. regards gourish On Mon, 14 Mar 2005 18:25:22 +1100, Russell Smith wrote: > On Mon, 14 Mar 2005 06:14 pm, Gourish Singbal wrote: > > Guys, > > > > I am having a problem firing queries on one of the tables which is > > having "limit" as the column name. > > > > If a run an insert/select/update command on that table i get the below error. > > > > ERROR: syntax error at or near "limit" at character 71 > > select "limit" from limit_table WHERE "limit" < 50 LIMIT 2; > > You need to quote the field name, and make sure the case is correct. > > > > Any Help would be realyl great to solve the problem. > > > > postgresql 7.4.5 and linux OS > > > You should probably upgrade to 7.4.7 > > Regards > > Russell Smith. > -- Best, Gourish Singbal