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 E48385643C for ; Mon, 14 Mar 2005 18:56:08 +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 21112-08 for ; Mon, 14 Mar 2005 18:56:06 +0000 (GMT) Received: from smtp103.mail.sc5.yahoo.com (smtp103.mail.sc5.yahoo.com [66.163.169.222]) by svr1.postgresql.org (Postfix) with SMTP id 36243563DE for ; Mon, 14 Mar 2005 18:56:03 +0000 (GMT) Received: from unknown (HELO jupiter.black-lion.info) (janwieck@68.80.245.191 with login) by smtp103.mail.sc5.yahoo.com with SMTP; 14 Mar 2005 18:56:02 -0000 Received: from [172.21.8.128] (ismtp.afilias.com [216.217.55.254]) (authenticated bits=0) by jupiter.black-lion.info (8.12.10/8.12.9) with ESMTP id j2EIu0OU027648; Mon, 14 Mar 2005 13:56:00 -0500 (EST) (envelope-from JanWieck@Yahoo.com) Message-ID: <4235DE36.2070608@Yahoo.com> Date: Mon, 14 Mar 2005 13:55:50 -0500 From: Jan Wieck User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.1) Gecko/20040707 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Robert Treat Cc: Christopher Kings-Lynne , Gourish Singbal , Russell Smith , pgsql-performance@postgresql.org Subject: Re: column name is "LIMIT" References: <674d1f8a0503132314754df153@mail.gmail.com> <200503141825.22827.mr-russ@pws.com.au> <674d1f8a05031400482c413087@mail.gmail.com> <42355185.3070803@familyhealth.com.au> <1110824915.4281.123.camel@camel> In-Reply-To: <1110824915.4281.123.camel@camel> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.122 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO, RCVD_IN_NJABL_DUL, RCVD_IN_SORBS_DUL X-Spam-Level: ** X-Archive-Number: 200503/274 X-Sequence-Number: 10979 On 3/14/2005 1:28 PM, Robert Treat wrote: > Yeah... how come no one told him "don't do that"? LIMIT is an SQL > reserved word, so it's likely to cause trouble in any database you try > to use it on... I'd strongly recommend renaming that column asap. You > can see other reserved words at > http://www.postgresql.org/docs/8.0/interactive/sql-keywords-appendix.html > > Robert Treat Note also that the Slony-I replication system has problems with column names identical to reserved words. This is rooted in the fact that the quote_ident() function doesn't quote reserved words ... as it IMHO is supposed to do. Jan > > On Mon, 2005-03-14 at 03:55, Christopher Kings-Lynne wrote: >> You will still need to use double quotes in 8.0.1... >> >> Chris >> >> Gourish Singbal wrote: >> > 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. >> >> >> > >> > >> > >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 2: you can get off all lists at once with the unregister command >> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #