Through reading the db schema, the deletion failure could be due to the the foreign key constrains betwen jbp_forum_topics and jbp_forum_posts.
Please comments. anonymous wrote : | | jbossportal=# \d jbp_forums_topics; | Table "public.jbp_forums_topics" | Column | Type | Modifiers | --------------------+-----------------------------+----------- | jbp_id | integer | not null | jbp_forum_id | integer | | jbp_view_count | integer | | jbp_replies | integer | | jbp_first_post_id | integer | | jbp_last_post_id | integer | | jbp_last_post_date | timestamp without time zone | | jbp_poster | integer | | jbp_type | integer | | jbp_status | integer | | jbp_subject | character varying(255) | | Indexes: | "jbp_forums_topics_pkey" PRIMARY KEY, btree (jbp_id) | Foreign-key constraints: | "fk6c1a04ca7892a9ba" FOREIGN KEY (jbp_forum_id) REFERENCES jbp_forums_forums(jbp_id) | "fk6c1a04ca577068cb" FOREIGN KEY (jbp_first_post_id) REFERENCES jbp_forums_posts(jbp_id) | "fk6c1a04ca145469a8" FOREIGN KEY (jbp_poster) REFERENCES jbp_forums_posters(jbp_id) | "fk6c1a04cac1b3e31f" FOREIGN KEY (jbp_last_post_id) REFERENCES jbp_forums_posts(jbp_id) | | jbossportal=# \d jbp_forums_posts | Table "public.jbp_forums_posts" | Column | Type | Modifiers | -----------------+-----------------------------+----------- | jbp_id | integer | not null | jbp_topic_id | integer | | jbp_edit_count | integer | | jbp_edit_date | timestamp without time zone | | jbp_create_date | timestamp without time zone | | jbp_subject | character varying(255) | | jbp_text | character varying(255) | | jbp_poster_id | integer | | Indexes: | "jbp_forums_posts_pkey" PRIMARY KEY, btree (jbp_id) | Foreign-key constraints: | "fkf2c0436d499bfc7a" FOREIGN KEY (jbp_poster_id) REFERENCES jbp_forums_posters(jbp_id) | "fkf2c0436dbfb64ffa" FOREIGN KEY (jbp_topic_id) REFERENCES jbp_forums_topics(jbp_id) | | | Yang View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3887415#3887415 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3887415 ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
