[Serusers] Problem with avpops (bug?): dbrow contains NULL fields

[Michael Ulitskiy]

Hello,

I'm having problems with avpops module that looks to me
as a bug. I'm using Postgres as database backend.
Here's the table structure:

users=# \d usr_preferences
                           Table "ser.usr_preferences"
  Column   |            Type             |               Modifiers
-----------+-----------------------------+----------------------------------------
 uuid      | character varying(64)       | not null default ''::character varying
 username  | character varying(100)      | not null default ''::character varying
 domain    | character varying(128)      | not null default ''::character varying
 attribute | character varying(32)       | not null default ''::character varying
 value     | character varying(128)      | not null default ''::character varying
 type      | integer                     | not null default 0
 modified  | timestamp without time zone | not null default now()
Indexes:
    "usr_preferences_pkey" primary key, btree (attribute, username, "domain")

As you can see all fields defined as NOT NULL and there can't
be any NULL values.
Here's what I do in ser.cfg:

# -- avpops params --
modparam("avpops", "avp_url", "postgres://SERDB_USER:SERDB_PW@DBHOST/users")
modparam("avpops","avp_aliases","alias_p=I:100;alias_s=I:101")
modparam("avpops","avp_table","usr_preferences")

route {
 if (!avp_db_load("$ruri","$alias_p/usr_preferences")) {
           log(1,"avp not found");
 } else {
    avp_print();
 }
 sl_reply_error();
}

When I'm sending the following INVITE:
INVITE sip:12128121207 at myserbox.com SIP/2.0
...

Here's the query that's sent to the database:
select value,attribute,type from usr_preferences 
where username='12128121207' AND attribute='100'

Here's the result of the query in psql:
users=# select value,attribute,type from usr_preferences where username='12128121207' AND attribute='100';
                value                | attribute | type
-------------------------------------+-----------+------
 sip:12128121207 at anotherbox.com | 100       |    2
(1 row)

As you can see there's no NULL values and everything looks correct so far.
But here's what I get in ser log:

 0(12042) val2str(): converting 100, 3
 0(12042) PG[217] str2valp got string sip:12128121207 at anotherbox.com
 0(12042) PG[217] str2valp got string 100
 0(12042) PG[193] str2valp got int 2
 0(12042) ERROR:avpops:dbrow2avp: dbrow contains NULL fields

I tried it with ser 0.9.0, cvs stable and cvs head all with the same result.
If this is not a bug, please point me to what I'm doing wrong.
Otherwise please consider it a bug report. I assume that this is PostgreSQL
support related as it seems people on the list were able to get it work
with MySQL.
Thank you,

Michael