Hi, Guiga

What's the nature of the errors? I found that PostgreSQL 6.5.3, when I tried
that with Orion and CMP, didn't like explicit NULL at all, so I edited
"config/database-schemas/postgresql.xml" to change null="" rather than
null="null". Then it worked fine. This strikes me as a bug in PostgreSQL
6.5.x, since the docs indicate that an explicit declaration of NULL on a
column is OK. Don't know about PostgreSQL 7.0.

It's worth adding that your PostgreSQL data-source in datasources.xml should
use the <schema> tag to explicitly specify the schema to use.

I'd say the best thing to do is to have a user logged into PostgreSQL and
manually run the offending statements that you see to isolate the problem.
Once you determine the discrepancy you can modify the database schema.

HTH, Arved Sandstrom

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Guilherme
Ceschiatti
Sent: Friday, September 15, 2000 2:15 AM
To: Orion-Interest
Subject: ATM example with PostgreSQL


Hi!

Has anyone tried the ATM example with postgresql ? Any CMP bean that I try
to
deploy can't create the tables correctly.

[]s
Guiga




Reply via email to