Base solution for your next web application
Open Closed

PostgreSQL add migration issue #11482

User avatar
0
attspacecom created

Hi,

this is aspnetzero v12 ( most latest one) with postgresql v7.0.0

error below is happened after add migration and couldnt update database

please advice on this

Go to accepted answer
7 Answer(s)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @attspacecom

    We will check this and get back to you in a short time.

  • User Avatar
    0
    attspacecom created

    Hello ismcagdas,

    I got to know that PostgreSQL has a 63 character limit on identifiers.

    Any solution for this?

  • User Avatar
    0
    m.aliozkaya created
    Support Team

    Hi @attspacecom,

    You can name constraint names manually like this answer https://stackoverflow.com/a/64527547.

  • User Avatar
    0
    attspacecom created

    Hi m.aliozkaya,

    So everytime i do need to update name manually is it?

    Is there any way to configure this?

  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @attspacecom

    This is a one time operation. If you have similar long FK names in the future, you need to do this for such FKs one time.

  • User Avatar
    0
    attspacecom created

    Hi ismcagdas, Noted on this.

    And there is another issue

    Already added this in startup

  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @attspacecom

    Have you added this before creating the migrations or after ? If it is after, could you remove migrations and create them again ?

Assignee
User avatar m.aliozkaya
Labels
None yet