{"action":"created","issue":{"url":"https://api.github.com/repos/seamusabshere/upsert/issues/72","repository_url":"https://api.github.com/repos/seamusabshere/upsert","labels_url":"https://api.github.com/repos/seamusabshere/upsert/issues/72/labels{/name}","comments_url":"https://api.github.com/repos/seamusabshere/upsert/issues/72/comments","events_url":"https://api.github.com/repos/seamusabshere/upsert/issues/72/events","html_url":"https://github.com/seamusabshere/upsert/issues/72","id":141158424,"number":72,"title":"PostgreSQL error » duplicate key value violates unique constraint \"pg_proc_proname_args_nsp_index\"","user":{"login":"jufemaiz","id":16481,"avatar_url":"https://avatars.githubusercontent.com/u/16481?v=3","gravatar_id":"","url":"https://api.github.com/users/jufemaiz","html_url":"https://github.com/jufemaiz","followers_url":"https://api.github.com/users/jufemaiz/followers","following_url":"https://api.github.com/users/jufemaiz/following{/other_user}","gists_url":"https://api.github.com/users/jufemaiz/gists{/gist_id}","starred_url":"https://api.github.com/users/jufemaiz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jufemaiz/subscriptions","organizations_url":"https://api.github.com/users/jufemaiz/orgs","repos_url":"https://api.github.com/users/jufemaiz/repos","events_url":"https://api.github.com/users/jufemaiz/events{/privacy}","received_events_url":"https://api.github.com/users/jufemaiz/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-03-16T02:58:44Z","updated_at":"2016-03-29T03:03:40Z","closed_at":null,"body":"```SQL\r\nERROR:  duplicate key value violates unique constraint \"pg_proc_proname_args_nsp_index\"\r\nDETAIL:  Key (proname, proargtypes, pronamespace)=(upsert2_1_0_measurement_data_sel_measurement_point_id2088041071, 23 1043 1043 23 1043 701, 2200) already exists.\r\n\r\n/var/app/current/vendor/bundle/ruby/2.0/gems/upsert-2.1.0/lib/upsert/connection/PG_Connection.rb:13:in `exec'\r\n/var/app/current/vendor/bundle/ruby/2.0/gems/upsert-2.1.0/lib/upsert/connection/PG_Connection.rb:13:in `execute'\r\n/var/app/current/vendor/bundle/ruby/2.0/gems/upsert-2.1.0/lib/upsert/merge_function/postgresql.rb:106:in `create!'\r\n/var/app/current/vendor/bundle/ruby/2.0/gems/upsert-2.1.0/lib/upsert/merge_function.rb:39:in `initialize'\r\n/var/app/current/vendor/bundle/ruby/2.0/gems/upsert-2.1.0/lib/upsert.rb:229:in `new'\r\n/var/app/current/vendor/bundle/ruby/2.0/gems/upsert-2.1.0/lib/upsert.rb:229:in `merge_function'\r\n/var/app/current/vendor/bundle/ruby/2.0/gems/upsert-2.1.0/lib/upsert.rb:218:in `row'\r\n/var/app/current/vendor/bundle/ruby/2.0/gems/upsert-2.1.0/lib/upsert/active_record_upsert.rb:6:in `block in upsert'\r\n/var/app/current/vendor/bundle/ruby/2.0/gems/activerecord-4.2.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'\r\n/var/app/current/vendor/bundle/ruby/2.0/gems/upsert-2.1.0/lib/upsert/active_record_upsert.rb:4:in `upsert'\r\n…\r\n```\r\n\r\nI'm using upsert as part of a background process (Delayed::Job) dealing with inbound data on PostgreSQL with a number of processors.\r\n\r\nPostgreSQL shows the following: http://www.postgresql.org/message-id/4B9EA2FD.8090902@agliodbs.com"},"comment":{"url":"https://api.github.com/repos/seamusabshere/upsert/issues/comments/202682884","html_url":"https://github.com/seamusabshere/upsert/issues/72#issuecomment-202682884","issue_url":"https://api.github.com/repos/seamusabshere/upsert/issues/72","id":202682884,"user":{"login":"jufemaiz","id":16481,"avatar_url":"https://avatars.githubusercontent.com/u/16481?v=3","gravatar_id":"","url":"https://api.github.com/users/jufemaiz","html_url":"https://github.com/jufemaiz","followers_url":"https://api.github.com/users/jufemaiz/followers","following_url":"https://api.github.com/users/jufemaiz/following{/other_user}","gists_url":"https://api.github.com/users/jufemaiz/gists{/gist_id}","starred_url":"https://api.github.com/users/jufemaiz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jufemaiz/subscriptions","organizations_url":"https://api.github.com/users/jufemaiz/orgs","repos_url":"https://api.github.com/users/jufemaiz/repos","events_url":"https://api.github.com/users/jufemaiz/events{/privacy}","received_events_url":"https://api.github.com/users/jufemaiz/received_events","type":"User","site_admin":false},"created_at":"2016-03-29T03:03:40Z","updated_at":"2016-03-29T03:03:40Z","body":"Just wondering if there was any thoughts on this one?"}}