[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