pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Robert Treat <xzilla@users.sourceforge.net>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Gourish Singbal <gourish@gmail.com>
Cc: Russell Smith <mr-russ@pws.com.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: column name is "LIMIT"
Date: 14 Mar 2005 13:28:34 -0500
Message-ID: <1110824915.4281.123.camel@camel> (raw)
In-Reply-To: <42355185.3070803@familyhealth.com.au>
References: <674d1f8a0503132314754df153@mail.gmail.com>
	<200503141825.22827.mr-russ@pws.com.au>
	<674d1f8a05031400482c413087@mail.gmail.com>
	<42355185.3070803@familyhealth.com.au>

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

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 <mr-russ@pws.com.au> 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)

-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL




view thread (13+ messages)  latest in thread

Message-ID: <1110824915.4281.123.camel@camel>
Permalink:  ../1110824915.4281.123.camel@camel/
Also on:    postgresql.org/message-id/1110824915.4281.123.camel@camel

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: xzilla@users.sourceforge.net, chriskl@familyhealth.com.au, gourish@gmail.com, mr-russ@pws.com.au
  Subject: Re: column name is "LIMIT"
  In-Reply-To: <1110824915.4281.123.camel@camel>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox