[
https://issues.apache.org/jira/browse/TC-11?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15613275#comment-15613275
]
ASF GitHub Bot commented on TC-11:
----------------------------------
GitHub user dangogh opened a pull request:
https://github.com/apache/incubator-trafficcontrol/pull/20
TC-11 use ON CONFLICT DO NOTHING instead of IGNORE for psql
loading seeds.sql errors out on `insert ignore ...`
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/dangogh/incubator-trafficcontrol
psql-seeds-ignore
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafficcontrol/pull/20.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 #20
----
commit 8c5df5927bb4b305d621567000aa068e58c85e8f
Author: Dan Kirkwood <[email protected]>
Date: 2016-10-27T20:55:16Z
use ON CONFLICT DO NOTHING instead of IGNORE for psql
----
> psql branch -- remove "insert ignore" from seeds.sql
> ----------------------------------------------------
>
> Key: TC-11
> URL: https://issues.apache.org/jira/browse/TC-11
> Project: Traffic Control
> Issue Type: Bug
> Components: Traffic Ops
> Affects Versions: 2.0.0
> Reporter: Dan Kirkwood
> Assignee: Dan Kirkwood
> Priority: Minor
> Fix For: 2.0.0
>
>
> mysql uses `insert ignore ...`, whereas postgres uses `insert ... on
> conflict do nothing;` for the equivalent
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
