I agree with Sach that postgres is a great database. Better
yet, the beta of 7.0.3 in cvs supports OUTER JOIN finally.
-tim
> -----Original Message-----
> From: Sach Jobb [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 17, 2001 2:36 PM
> To: Orion-Interest
> Subject: RE: Is combining Orion and PostgreSQL a good choice
>
>
> That could very well be. We were using postgres 7.0.1 and it
> may have been
> a known bug.
>
> Tell you what, Randahl, if you end up having issues with date
> let me know
> and i'll send you our driver hack. I fully recommend
> postgres, it's by far
> my favorite opensource database.
>
> sach
> robot6
>
> %s/windows/linux/g
>
>
> On Wed, 17 Jan 2001, Tim Drury wrote:
>
> >
> > I use the latest postgresql jdbc driver that came
> > with 7.0.2 and this postgresql.xml database config
> > file and everything works fine for me.
> >
> > -tim
> >
> > <?xml version="1.0"?>
> > <!DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema"
> > "http://www.orionserver.com/dtds/database-schemas.dtd">
> >
> > <database-scheme name="PostGreSQL"
> max-table-name-length="25" not-null="not
> > null" null="" primary-key="primary key">
> >
> > <type-mapping type="java.lang.String" name="varchar" />
> > <type-mapping type="java.lang.Integer" name="int8" />
> > <type-mapping type="int" name="int4" />
> > <type-mapping type="long" name="int8" />
> > <type-mapping type="float" name="float4" />
> > <type-mapping type="double" name="float8" />
> > <type-mapping type="byte" name="int2" />
> > <type-mapping type="char" name="char" />
> > <type-mapping type="short" name="int2" />
> > <type-mapping type="boolean" name="bool" />
> > <type-mapping type="java.util.Date" name="timestamp" />
> > <type-mapping type="java.io.Serializable" name="oid" />
> > <type-mapping type="java.math.BigDecimal" name="decimal" />
> >
> > <disallowed-field name="parent" />
> > <disallowed-field name="password" />
> > <disallowed-field name="username" />
> > <disallowed-field name="date" />
> > <disallowed-field name="order" />
> > <disallowed-field name="old" />
> > <disallowed-field name="user" />
> > </database-scheme>
> >
> > > -----Original Message-----
> > > From: Randahl Fink Isaksen [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, January 17, 2001 11:21 AM
> > > To: Orion-Interest
> > > Subject: RE: Is combining Orion and PostgreSQL a good choice
> > >
> > >
> > > Interesting... but are you stating that without fixing bugs
> > > in the JDBC
> > > driver for PostgreSQL, it just will not work? If so, I would
> > > of course like
> > > to hear what you fixed exactly...
> > >
> > > Yours
> > >
> > > Randahl
> > >
> > > -----Original Message-----
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED]]On Behalf Of Mike
> > > Cannon-Brookes
> > > Sent: 17. januar 2001 13:51
> > > To: Orion-Interest
> > > Subject: RE: Is combining Orion and PostgreSQL a good choice
> > >
> > >
> > > I'm using PostgreSQL on an application that is about to go
> > > live (within the
> > > next month). Seems to be working fine in testing so far,
> > > we're moving off
> > > Sybase 11.0.3.3 on Linux to PostgreSQL (probably 7.1 by
> the time we go
> > > live).
> > >
> > > I've personally fixed a bug or two in the JDBC driver, but
> > > other than that
> > > the latest driver seems very solid.
> > >
> > > I use the default schema (the latest one from Orion has a
> lot of fixes
> > > contributed by myself and others, the original was horrible).
> > > Let me know if
> > > there are any problems with the latest schema.
> > >
> > > -mike
> > >
> > > > -----Original Message-----
> > > > From: [EMAIL PROTECTED]
> > > > [mailto:[EMAIL PROTECTED]]On Behalf Of
> > > Randahl Fink
> > > > Isaksen
> > > > Sent: Wednesday, January 17, 2001 11:01 PM
> > > > To: Orion-Interest
> > > > Subject: Is combining Orion and PostgreSQL a good choice
> > > >
> > > >
> > > > I am wondering if using PostgreSQL with Orion would be a good
> > > > option. So my
> > > > questions are:
> > > >
> > > > 1. Has anyone tried using PostgreSQL with Orion in a
> > > real-life application
> > > > (running for a long period with no errors) - and was it
> a success?
> > > >
> > > > 2. Do you use the default database schema for PostgreSQL
> > > that comes with
> > > > Orion?
> > > >
> > > >
> > > > Yours
> > > >
> > > > Randahl
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
>
>
