From: Jan Wieck <JanWieck@Yahoo.com>
To: Robert Treat <xzilla@users.sourceforge.net>
Cc: 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: Mon, 14 Mar 2005 13:55:50 -0500
Message-ID: <4235DE36.2070608@Yahoo.com> (raw)
In-Reply-To: <1110824915.4281.123.camel@camel>
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>
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 <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)
>
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
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: JanWieck@Yahoo.com, 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: <4235DE36.2070608@Yahoo.com>
* 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