Do you remember what version of PostgreSQL this was? Was it a release or
beta?
--On Monday, August 14, 2000 12:06 PM -0400 KirkYarina
<[EMAIL PROTECTED]> wrote:
> FWIW, we found major problems with postgresql. Running a test that
> created and deleted EBs caused index and data files to grow continuously.
> Recovering data space took a "vacuum" command, but the only way to
> recover deleted index file space was to copy tables. In addition every
> test run was slower than the one before it - from my notes when run 3
> times each run took twice as long as the one before. The same tests took
> the same time every run when using Hypersonic or Sybase.
>
> This was several months ago, so perhaps it's been fixed. We deleted
> postgres and moved on...
>
> Our old data-sources.xml section is below, just in case it helps. I
> believe I had to edit the database-schema file to change null="null" to
> null="" also.
>
> Kirk Yarina
>
> At 05:58 PM 8/12/00 -0700, you wrote:
>> Are the postgres drivers built in to orion? I want to make some changes
>> to them.
>>
>> I'm trying to use postgres as my datasource in Orion. It sets up fine,
>> but I need to make some changes to the driver implementation. I'm
>> having a bunch of problems with the date and timestamp implementations.
>> I found on the PostGres mailing lists that it's a pretty common problem
>> and you just have to modifiy ResultSet for your setup.
>>
>> The problem I'm having is that I can't seem to override the drivers in
>> orion. I've tried putting a jar of postgres drivers in the orion/lib
>> directory, but it still seems to be using some other drivers.
>>
>> -Lkb
>> /**
>> * @author: Lorin Kobashigawa-Bates <[EMAIL PROTECTED]>
>> * @title: CodeMonkey / COO - Robot6 Inc.
>> * @phone: 415.345.8872
>> * @addr: 1177 Polk St. San Francisco, CA 94109
>> */
>
> from datasources.xml:
>
> <data-source
> name="Default data-source"
> class="com.evermind.sql.ConnectionDataSource"
> location="jdbc/DefaultDS"
> pooled-location="jdbc/DefaultPooledDS"
> xa-location="jdbc/xa/DefaultXADS"
> ejb-location="jdbc/DefaultEJBDS"
> url="jdbc:postgresql://ourhost/ejbtest"
> connection-driver="org.postgresql.Driver"
> username="admin"
> password="123"
> schema="database-schemas/postgresql.xml"
> />
>
>
> Kirk Yarina
> [EMAIL PROTECTED]
>
