[Jboss-dev-forums] [Design of JBoss Portal] - ForumsPortlet post deletion failure

[yxyang <nu...@jb...>]

Hi 

(For Jbp-2.0 branch)

I experienced the deletion of a posts failure. I went through the database schema of jbp_forums_****

I found the foreign key constrains between jbp_forums_topics and jbp_forums_posts are a bit strange. That is to say, the foreign key constrain is bi-direction. Is this correct?

I cannot even delete them manually through psql console.

Please help!

anonymous wrote : 
  | 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)
  | 
  | 
  | 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)
  | 
  | 
  | 

Thanks
yang

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3887416#3887416

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3887416