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
|
