#221 Empty trigger in tables and wrong metadata

v0.9.4
closed
nobody
None
1
2015-05-13
2012-11-16
No

FB WI-V2.5.0.26074
FR 0.9.2.1851

tables show serveral empty triggers named CHECK_X where X is a number.
extracting metadata there are created several triggers as:

SET TERM ^ ;
CREATE TRIGGER CHECK_22 FOR tablename ACTIVE
AFTER UPDATE POSITION 1
^
SET TERM ; ^

and the metadata file can't be executed as these statements are all wrong.

It's a bug or ... ???
thank you.

Discussion

  • Michael Hieke

    Michael Hieke - 2012-11-16

    The FlameRobin version you use is quite old, and the problem may well have been fixed already. Could you please try with the latest snapshot which you can download here?

     
    • Fabrizio Villanova

      downloaded v. 0.9.3 1186200

      table triggers still presents. Nothing changed.
      Trying the new 'generate rebuild script for that column' the metadata generated shows the empty trigger above mentioned.

      Extract metadata function not found. Where is it now?

       
      Last edit: Fabrizio Villanova 2012-11-16
  • Michael Hieke

    Michael Hieke - 2012-11-16

    Metadata for single database objects or the full database can be found on the respective property pages.

    I'm happy to look into this if you can provide a script to recreate the problem with an empty database, or if you can put the database in question (all data deleted would be OK too) somewhere for me to download.

    I haven't seen that problem yet.

     
  • Fabrizio Villanova

    metadata found... no changes in the bad trigger generation.

    i'll try the ''recreate an empty database function'' to build a database with the reported errors. Seems that this triggers are linked with constraints. i have tried some time ago dropping them and i needed to retrieve a backup...
    How to deliver it to you? (tomorrow, now in italy is dinner time!)

    bye

     
  • Michael Hieke

    Michael Hieke - 2012-11-16

    You could mail the backup to mghie@users.sourceforge.net, thanks

     
  • Popa Adrian Marius

     
  • Popa Adrian Marius

    need more info or db sql dump

     
  • Popa Adrian Marius

    • status: open --> closed
     


Anonymous

Cancel  Add attachments





Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks