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

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  Created:
                  Updated: