#221 Empty trigger in tables and wrong metadata

v0.9.4
open
nobody
None
1
2012-11-16
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?

     
    • 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.

     
  • 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

     


Anonymous


Cancel   Add attachments