[rt-devel] Rt and Oracle

Jesse jesse at fsck.com
Wed Apr 12 12:24:24 EDT 2000


Cool. In my book, supporting oracle 8 and not oracle 7 would not be a great loss.


On Wed, Apr 12, 2000 at 10:06:23AM -0600, Aryeh Cody Sherr wrote:
> 
> Oracle supports auto increment with triggers. It also has support for
> character and large objects both, at least in 8 and 8i. I don't know about
> 7.
> 
> Cody
> 
> On Wed, 12 Apr 2000, Dylan Vanderhoof wrote:
> 
> >I can't speak for Oracle, but I know that DB2 has support for the BLOB type,
> >althought it akes fairly excessive use of binds.  I'll have to de some
> >research for that.
> >Also, I have a trigger for DB2 that will likely work with Oracle as well
> >with some tweaking to emulate MySQL's AUTO_INCREMENT column variable.
> >
> >Dylan C. Vanderhoof
> >Internal Software Developer
> >Semaphore Corporation
> >
> >-----Original Message-----
> >From: Tobias Brox [mailto:tobiasb at tobiasb.funcom.com]
> >Sent: Wednesday, April 12, 2000 1:04 AM
> >To: Jesse
> >Cc: Aryeh Cody Sherr; Dylan Vanderhoof; 'rt-devel at lists.fsck.com'
> >Subject: Re: [rt-devel] Rt and Oracle
> >
> >
> >> Other issues that need to be dealt with is the fact that the Attachments
> >> table uses MySQL's blob support which may or may not be easily portable. 
> >
> >Another issue is the primary keys.  MySQL has "autoincrement" which means
> >that a NULL value might be issued for the primary key, and MySQL will find
> >the number itself and return it.  Different engines do have different ways
> >of handling this, as well as different ways of returning the number.
> >
> >-- 
> >Tobias Brox 
> >aka TobiX
> >+47 22 925 871
> >
> >
> >
> >
> >_______________________________________________
> >Rt-devel mailing list
> >Rt-devel at lists.fsck.com
> >http://lists.fsck.com/mailman/listinfo/rt-devel
> >
> 
> 
> 
> 
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
> 

-- 
jesse reed vincent -- jrvincent at wesleyan.edu -- jesse at fsck.com 
pgp keyprint:  50 41 9C 03 D0 BC BC C8 2C B9 77 26 6F E1 EB 91
--------------------------------------------------------------
"It's buried in the desert, got sand in it, melts Nazis. You know,
the Ark of the Covenant"   -- siva





More information about the Rt-devel mailing list