[JBoss-user] [Nukes User] - Re: Unique pkey constraint problems w/PostgreSQL

2004-10-22 Thread tasj2ee
Ok, For the record: The problem occurred because the sequences for the serial primary keys of the nukes tables were not incremented after populating the default data installed by the nukes-installer (see postgres.xml in nukes-installer.war). For example, the nukes-installer creates the nuke_f

[JBoss-user] [Nukes User] - Unique pkey constraint problems w/PostgreSQL

2004-10-15 Thread tasj2ee
Hello, I've run into a problem trying out nukes 1.1 RC3 with PostgreSQL. It looks like some entities aren't getting unique primary keys. If I attempt to update and save an HTML page using the HTML module I consistently get an error and the postgres console says: ERROR: duplicate key violate