PostgreSQL code generator : <relation> in DB naming for forum key column (dbForeignKeyColumn) is not taken into account

28 views
Skip to first unread message

Jean-Michel Nil

unread,
Nov 18, 2014, 2:30:14 AM11/18/14
to risee...@googlegroups.com
Hello

I am just starting testing the Rise editor. I may use it to maintain a PostgreSQL database.

For generating the code I have changed the database naming convention which works fine for everything except for the foreign key generated from 0..1-n relation.
I specified PF_<relation> in the DB naming convention which also seems to be correct in the project fie (see below extract if the XML.
But when I generate the code I obtain only PK_ as column name. 

Thanks
 
    <rise:dbNaming>
      <rise:dbTablePrefix />
      <rise:dbTableDeletedPrefix>d_</rise:dbTableDeletedPrefix>
      <rise:dbEntityTable>&lt;entity&gt;</rise:dbEntityTable>
      <rise:dbRelationTable>&lt;relation&gt;</rise:dbRelationTable>
      <rise:dbColumnPrefix />
      <rise:dbColumnDeletedPrefix>d_</rise:dbColumnDeletedPrefix>
      <rise:dbIdColumn>id</rise:dbIdColumn>
      <rise:dbAttributeColumn>&lt;attribute&gt;</rise:dbAttributeColumn>
      <rise:dbForeignKeyColumn>FK_&lt;relation&gt;</rise:dbForeignKeyColumn>
      <rise:dbDefaultValueConstraint>df_&lt;model&gt;_&lt;typedtable&gt;_&lt;typedcolumn&gt;</rise:dbDefaultValueConstraint>
      <rise:dbUniqueConstraint>ix_&lt;model&gt;_&lt;typedtable&gt;_&lt;typedcolumn&gt;</rise:dbUniqueConstraint>
      <rise:dbCheckConstraint>ck_&lt;model&gt;_&lt;typedtable&gt;_&lt;typedcolumn&gt;</rise:dbCheckConstraint>
      <rise:dbForeignKeyConstraint>fk_&lt;model&gt;_&lt;typedtable&gt;_&lt;typedcolumn&gt;</rise:dbForeignKeyConstraint>
      <rise:dbExternalForeignKeyConstraint>xf_&lt;model&gt;_&lt;typedtable&gt;_&lt;typedcolumn&gt;</rise:dbExternalForeignKeyConstraint>
      <rise:dbIndex>idx_&lt;model&gt;_&lt;typedtable&gt;_&lt;index&gt;</rise:dbIndex>
      <rise:dbTable>&lt;tableprefix&gt;&lt;typedtable&gt;</rise:dbTable>
      <rise:dbColumn>&lt;columnprefix&gt;&lt;typedcolumn&gt;</rise:dbColumn>
      <rise:dbView>&lt;view&gt;</rise:dbView>
    </rise:dbNaming>

Reply all
Reply to author
Forward
0 new messages