diff options
| author | =Corey Hulen <corey@hulen.com> | 2016-02-22 16:31:19 -0800 |
|---|---|---|
| committer | =Corey Hulen <corey@hulen.com> | 2016-02-22 16:31:19 -0800 |
| commit | 28ab0d835878bf1ad72dbae914ca112acfbe490d (patch) | |
| tree | 98986ee8cf1c3e56d5768a56b1d799bd82569e44 /store/sql_store.go | |
| parent | 1bb85818ca5d7569c17e56d523d9668b83973e65 (diff) | |
| download | chat-28ab0d835878bf1ad72dbae914ca112acfbe490d.tar.gz chat-28ab0d835878bf1ad72dbae914ca112acfbe490d.tar.bz2 chat-28ab0d835878bf1ad72dbae914ca112acfbe490d.zip | |
Fixing postgres
Diffstat (limited to 'store/sql_store.go')
| -rw-r--r-- | store/sql_store.go | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/store/sql_store.go b/store/sql_store.go index 9e22191b4..de23f4db3 100644 --- a/store/sql_store.go +++ b/store/sql_store.go @@ -389,7 +389,7 @@ func (ss SqlStore) GetMaxLengthOfColumnIfExists(tableName string, columnName str if utils.Cfg.SqlSettings.DriverName == model.DATABASE_DRIVER_MYSQL { result, err = ss.GetMaster().SelectStr("SELECT CHARACTER_MAXIMUM_LENGTH FROM information_schema.columns WHERE table_name = '" + tableName + "' AND COLUMN_NAME = '" + columnName + "'") } else if utils.Cfg.SqlSettings.DriverName == model.DATABASE_DRIVER_POSTGRES { - result, err = ss.GetMaster().SelectStr("SELECT character_maximum_length FROM information_schema.columns WHERE table_name = '" + tableName + "' AND column_name = '" + columnName + "'") + result, err = ss.GetMaster().SelectStr("SELECT character_maximum_length FROM information_schema.columns WHERE table_name = '" + strings.ToLower(tableName) + "' AND column_name = '" + strings.ToLower(columnName) + "'") } if err != nil { @@ -410,7 +410,7 @@ func (ss SqlStore) AlterColumnTypeIfExists(tableName string, columnName string, if utils.Cfg.SqlSettings.DriverName == model.DATABASE_DRIVER_MYSQL { _, err = ss.GetMaster().Exec("ALTER TABLE " + tableName + " MODIFY " + columnName + " " + mySqlColType) } else if utils.Cfg.SqlSettings.DriverName == model.DATABASE_DRIVER_POSTGRES { - _, err = ss.GetMaster().Exec("ALTER TABLE " + tableName + " ALTER COLUMN " + columnName + " TYPE " + mySqlColType) + _, err = ss.GetMaster().Exec("ALTER TABLE " + strings.ToLower(tableName) + " ALTER COLUMN " + strings.ToLower(columnName) + " TYPE " + postgresColType) } if err != nil { |