[Users] avpops, duplicate key, empty username and domain

JF jfkavaka at gmail.com
Wed Feb 8 14:11:09 CET 2006


Great!

Thank you, Bogdan.
Another useful feature would be a new function avp_db_update(), which
would do SQL UPDATEs instead of having to do avp_db_delete() and then
avp_db_store(). This probably involves touching the db api...

JF

On 2/8/06, Bogdan-Andrei Iancu <bogdan at voice-system.ro> wrote:
> Hi,
>
> I just changed the PK definition to allow definition of same AVP but
> with multiples values. Also to speed up the lookup indexes based on uuid
> or username/domain were added.
>
> regards,
> bogdan
>
> JF wrote:
>
> >Hi,
> >
> >I'm trying to use avpops module, but I'm facing the following error:
> >
> > 0(8178) PG[367] submit_query query 'insert into usr_preferences
> >(uuid,attribute,value,type,username,domain ) values
> >('test','avpname','test',0,'','')', result 'ERROR:  duplicate key
> >violates unique constraint "usr_preferences_pkey"
> >
> >It seems to be caused by the username and domain parameters being
> >empty strings, since the usr_preferences table has this PK constraint:
> > "usr_preferences_pkey" primary key, btree (attribute, username,
> >"domain")
> >
> >The avpops module is configured like this:
> >modparam("avpops", "avp_url", "postgres://xpto:xpto@127.0.0.1/xpto")
> >modparam("avpops", "avp_table", "usr_preferences")
> >modparam("avpops","use_domain",1)
> >modparam("avpops", "avp_aliases", "avpalias=s:avpname")
> >
> >And I'm simply doing:
> >avp_printf("s:avpname", "test");
> >avp_db_store("$avpalias/uuid", "s:avpname");
> >
> >What may be missing? Maybe the usr_preferences table should not have
> >this PK when using UUID-based AVP identification...
> >
> >JF
> >
> >_______________________________________________
> >Users mailing list
> >Users at openser.org
> >http://openser.org/cgi-bin/mailman/listinfo/users
> >
> >
> >
>
>




More information about the Users mailing list