GitHub user mitchell852 opened a pull request:
https://github.com/apache/incubator-trafficcontrol/pull/66
Fix psql migration to convert the right stuff to bools and leave other
stuff alone
pgloader converts all tinyints to smallints but some of these need to be
converted to bools and some need to be left as smallints. this migration
converts the appropriate ones to bools.
here are the tinyints that get converted to bools
cdn.dnssec_enabled
ds.active
ds.signed
ds.ipv6_routing_enabled
ds.multi_site_origin
ds.regional_geo_blocking
ds.logs_enabled
parameter.secure
server.upd_pending
tm_user.new_user
to_extension.isactive
and here are the tinyints that will stay as smallints
ds.qstring_ignore
ds.geo_limit
ds.protocol
ds.range_request_handling
ds.geo_provider
ds.multi_site_origin_algorithm
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/mitchell852/incubator-trafficcontrol
fix-psql-migration
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafficcontrol/pull/66.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #66
----
commit 69d1e257efe184a36c91a5c152cb996de56e9096
Author: Jeremy Mitchell <[email protected]>
Date: 2016-11-09T18:52:19Z
the migration basically includes 2 things -1) converts double to numeric
and 2) converts certain smallints to bool
commit d2d4b762fa4299c27d7e6cd5c2aa037289193765
Author: Jeremy Mitchell <[email protected]>
Date: 2016-11-09T20:04:49Z
more tweaks to migration and added the goose down part
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
