Welcome to ModelRight Database Design Tool - Database Modeling Done Right Sign in | Join | Help
in
ModelRight Database Design Too... » ModelRight » Modeling » Changing default column value does not generate in Change Script (PGSQL)

Changing default column value does not generate in Change Script (PGSQL)

Last post 08-27-2009, 8:28 PM by admin. 4 replies.
Sort Posts: Previous Next

  •  08-21-2009, 1:24 AM 1302

    Changing default column value does not generate in Change Script (PGSQL)

    Reply Quote

    Hi Team,

     I just went through and updated the default value of about 150 columns from the imported

    "current_user"() 

    to CURRENT_USER (not quoted)

    and the change generator did not pick up on it. Any chance of having a look at this?

     

    Edit:

    I just used the "compare database" feature and it picked up on the differences. However, it has taken my new default as a string "CURRENT_USER" rather than keyword CURRENT_USER - so it's still not right, but for a different reason. 

    Regards,

    TM 

  •  08-24-2009, 11:38 PM 1303 in reply to 1302

    Re: Changing default column value does not generate in Change Script (PGSQL)

    Reply Quote
    Any update on this one?

  •  08-25-2009, 10:58 AM 1305 in reply to 1303

    Re: Changing default column value does not generate in Change Script (PGSQL)

    Reply Quote
    Sorry for the delay.  Vacations...  Will have a fix later today.
    Scott Reynolds
    Technical Support Engineer
    ModelRight, Inc.
    www.modelright.com
    p: (609) 423-9296
    f: (866) 812-3742

  •  08-27-2009, 6:38 PM 1307 in reply to 1305

    Re: Changing default column value does not generate in Change Script (PGSQL)

    Reply Quote
    No worries. That project is on the backburner at the moment anyway. Take your time.

  •  08-27-2009, 8:28 PM 1308 in reply to 1307

    Re: Changing default column value does not generate in Change Script (PGSQL)

    Reply Quote
    This has been fixed in build 3520.
    Scott Reynolds
    Technical Support Engineer
    ModelRight, Inc.
    www.modelright.com
    p: (609) 423-9296
    f: (866) 812-3742
[email protected]    609-423-9296    /    [email protected]    609-423-9297        Copyright @ 2006-2009 ModelRight, Inc. All rights reserved.