[ic] Postgres + Debian error

Rene Hertell interchange at hertell.com
Wed Jan 3 05:47:48 EST 2007


Jon Jensen wrote:
> Given the error message:
> 
>> set_row error as called by Vend::Table::DBI: DBD::Pg::db do failed:
>> ERROR:  null value in column "password" violates not-null constraint
> 
> it sure sounds to me like a simple problem of your Interchange table
> import trying to put a NULL entry in the password field. Why don't you
> make "password" allow NULL and see if it stops complaining? If so, then
> you'll know what's wrong and can try to find out where the NULL password
> is coming from.

Yep, That was it. Removing the Not NULL worked..

But I wonder why it gave me that error, because removing the "not null"
saved that password anyway in the password column as expected...


René


More information about the interchange-users mailing list