Uploaded image for project: 'COmanage'
  1. COmanage
  2. CO-165

Schema update generates "Possibly failed to update database schema"

    XMLWordPrintable

Details

    Description

      When running "./cake database" to update an existing database schema, "Possibly failed to update database schema" is generated. This is because ParseSchema (called in DatabaseShell::main) is generating bad SQL for Postgres.

      eg: ALTER TABLE cm_cos ALTER COLUMN id SERIAL
      which (1) should be ALTER TABLE cm_cos ALTER COLUMN id TYPE SERIAL
      and (2) SERIAL isn't usable in an ALTER TABLE statement

      Attachments

        Issue Links

          Activity

            People

              tzeller Tom Zeller (Inactive)
              benn.oshrin@at.internet2.edu Benn Oshrin (internet2.edu)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: