4 Replies Latest reply on Feb 26, 2010 12:07 PM by Adam Warski

    Envers with Postgresql - wrong schema creation

    Przem Jask Newbie

      Hi,

       

      Looks like there is a problem when using Envers with postgresql. During schema creation none of the AUD tables is created due to:

       

      * 2010-02-19 08:59:30,730 [] [main] 
        ERROR SchemaUpdate.execute():212
        Unsuccessful: create table entities.ItemsCompilation_AUD (originalId.id int8 not null, originalId.REV int4 not null, revtype int2, primary key (originalId.id, originalId.REV))
      * 2010-02-19 08:59:30,730 [] [main] 
        ERROR SchemaUpdate.execute():213
        ERROR: syntax error at or near "."

       

       

      Look like column names "originalId.id" "originalId.REV" are illegal.

       

       

      Any ideas how to solve this?

       

      TIA,

      Przemek