[jbosstools-issues] [JBoss JIRA] Commented: (JBIDE-8606) Reverse Engineering FK-Detection in parent table

[Max Rydahl Andersen (JIRA)]

    [ https://issues.jboss.org/browse/JBIDE-8606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12601510#comment-12601510 ] 

Max Rydahl Andersen commented on JBIDE-8606:
--------------------------------------------

sounds like postgressql is not reporting back consistent JDBC metadata...or that we need to query additional data to get the full view ?

> Reverse Engineering FK-Detection in parent table
> ------------------------------------------------
>
>                 Key: JBIDE-8606
>                 URL: https://issues.jboss.org/browse/JBIDE-8606
>             Project: Tools (JBoss Tools)
>          Issue Type: Feature Request
>          Components: Hibernate
>    Affects Versions: LATER
>         Environment: winxp32 vista64 postgresql8.3
>            Reporter: Peter Rader
>             Fix For: 3.3.x
>
>   Original Estimate: 5 hours
>  Remaining Estimate: 5 hours
>
> Postgresql does allow to inherit a table from another table.
> But the RevEng does not detect Foregin-keys from parent table.
> Example:
> CREATE TABLE changed (
>   created_from_user_id INTEGER NOT NULL,
>   CONSTRAINT "created_user" FOREIGN KEY ("created_from_user_id") REFERENCES user("user_id")
> )
> CREATE TABLE guestbook (
>   caption TEXT,
> ) INHERITS (changed)
> insert into guestbook (1,'hi')
> RevEng will create 
>   public int getCreatedFromUserId()
> instead of
>   public User getCreatedFromUser()
> what i expected to become.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira