Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!news.tiscali.de!tiscali!newsfeed1.ip.tiscali.net!proxad.net!64.233.160.134.MISMATCH!postnews.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!local01.nntp.dca.giganews.com!nntp.pipex.net!news.pipex.net.POSTED!not-for-mail
NNTP-Posting-Date: Thu, 04 Jan 2007 15:32:57 -0600
Date: Thu, 04 Jan 2007 21:41:03 +0000
From: Niall Litchfield <niall.litchfield@dial.pipex.com>
User-Agent: Thunderbird 1.5.0.7 (X11/20060911)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Is this a bug?
References: <1167853573.172687.246190@i12g2000cwa.googlegroups.com>   <1167854463.775447.38350@n51g2000cwc.googlegroups.com> <1167862701.878511.317540@s34g2000cwa.googlegroups.com> <1167866459.800948@bubbleator.drizzle.com> <5033i4F1ee0q1U1@mid.individual.net> <1167929230.952378@bubbleator.drizzle.com>
In-Reply-To: <1167929230.952378@bubbleator.drizzle.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Message-ID: <ErOdnanuYoMU7wDYnZ2dnUVZ8sXinZ2d@pipex.net>
Lines: 20
NNTP-Posting-Host: 81.179.178.127
X-Trace: sv3-jJiaHe3ys+NV6OsJCkqAR13I7TH9lnhtHth8Fjw6qm7QNnbKkq19krTSqdPV7QLpb+SiYfNukBXAh03!to42fXTLs5DiZwRSo3oRV+pdwvxWo4qxaZk7Bqms1qdB8LxM6r3oxvAsdrxhLEwMHb6kl9kCOrkM!W/5tlsiSWPI43qQ+zGeYMHPmHS4=
X-Complaints-To: abuse@dsl.pipex.net
X-DMCA-Complaints-To: abuse@dsl.pipex.net
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.32
Xref: news.f.de.plusline.net comp.databases.oracle.server:191746

DA Morgan wrote:
> Serge Rielau wrote:
> 
>>> I'm not quite sure I can agree that something violating Oracle's advice,
>>> and generating an error, is a bug. At least not as long as the word
>>> TIMESTAMP is present in gv$reserved_words.
>> I wish my customers were as tolerant as you are....
> 
> When a company goes to the effort to put a reference of keywords into
> their product then it becomes the obligation of the developers and DBAs
> to use it.

It would be nice though if reserved words were always reserved though,
that is the column couldn't have been created in the first place - not
that that worked fine but the trigger fails.

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info/services
