From torque-user-return-4579-apmail-db-torque-user-archive=db.apache.org@db.apache.org Thu Apr 01 16:27:14 2004 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 3948 invoked from network); 1 Apr 2004 16:27:14 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 1 Apr 2004 16:27:14 -0000 Received: (qmail 1065 invoked by uid 500); 1 Apr 2004 16:26:53 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 1042 invoked by uid 500); 1 Apr 2004 16:26:53 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 975 invoked from network); 1 Apr 2004 16:26:52 -0000 Received: from unknown (HELO eufig1.rit.reuters.com) (194.205.123.3) by daedalus.apache.org with SMTP; 1 Apr 2004 16:26:52 -0000 Received: from no.name.available by eufig1.rit.reuters.com via smtpd (for daedalus.apache.org [208.185.179.12]) with SMTP; 1 Apr 2004 16:26:55 UT Received: from eupig1 (unverified) by dtcseuvig4.dtc.lon.ime.reuters.com (Content Technologies SMTPRS 4.3.10) with ESMTP id for ; Thu, 1 Apr 2004 17:26:39 +0100 Message-ID: Received: from dtcsmsxb01.emea.ime.reuters.com ([10.5.150.13]) by eupig1.dtc.lon.ime.reuters.com (PMDF V6.1-1 #30693) with ESMTP id <0HVI0043X30IJ0@eupig1.dtc.lon.ime.reuters.com> for torque-user@db.apache.org; Thu, 01 Apr 2004 16:26:42 +0000 (GMT) Received: from LONSMSXM01.emea.ime.reuters.com ([10.5.150.34]) by dtcsmsxb01.emea.ime.reuters.com with Microsoft SMTPSVC (5.0.2195.6713); Thu, 01 Apr 2004 17:26:11 +0100 Date: Thu, 01 Apr 2004 17:26:11 +0100 From: Bob Davison Subject: RE: Oracle 9i TIMESTAMP in primary key problems To: Apache Torque Users List MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft Exchange V6.0.6375.0 Content-type: text/plain; charset="us-ascii" Content-transfer-encoding: quoted-printable Thread-Topic: Oracle 9i TIMESTAMP in primary key problems Thread-Index: AcQYAeXGCK3BTBlfSGOmGyAkTFoMEgAA4g+Q content-class: urn:content-classes:message X-MS-Has-Attach: X-MS-TNEF-Correlator: X-OriginalArrivalTime: 01 Apr 2004 16:26:11.0865 (UTC) FILETIME=[0BB75090:01C41806] X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Dave, I am sure you have a good point. I didn't really like it when I came across the 'date in primary key' either but had no real reason to change until now. I guess my mail was to alert anyone else following this route to the problem. We don't all have control over the schemas we have to write code for. .../Bob -----Original Message----- From: Dave Newton [mailto:dave@solaraccess.com]=20 Sent: 01 April 2004 16:55 To: Apache Torque Users List Subject: RE: Oracle 9i TIMESTAMP in primary key problems > From: Bob Davison [mailto:Bob.Davison@reuters.com] > Due to the problems with the Oracle 9i JDBC drivers and DATE columns we > moved to TIMESTAMP columns instead. This seemed fine until we used one > of these columns in a primary key. Totally unrelated, but I thought using "real-world data" as a primary key (or portion thereof) was generally a no-no in the DB world. Did I misunderstand? Dave --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org --------------------------------------------------------------- - Visit our Internet site at http://www.reuters.com Get closer to the financial markets with Reuters Messaging - for more information and to register, visit http://www.reuters.com/messaging Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd. --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org