how to configure postgres not to show not null constraint error

Question

I'm installing openbravo. The install log shows a heap of SQL errors which are all "not null" constraints errors.

I already searched quite a while for how to fix this, but they only say how to drop the not null constraint in a single table.

What I want is to configure the PostgreSQL server to run in a loosen state which doesn't complain the "not null" at all. I know there is an option for MySQL, but I don't know what is it for PostgreSQL.

---

Update: I have eliminated the install error by unchecking "install sample data"' option. What a hard and simple fix!

Answer 1

i know there is an option for mysql, dont know what is it for postgres

Contrary to MySQL the PostgreSQL server does not offer a way to shred your data in such a simple way. Your only chance is to remove the NOT NULL constraints from your tables.

BTW: If the constraints are not important - as you say - why are they there at all?

Answer 2

You can't to do it. There are no any global switch that allows a "loosen state"