Skip to content

Instantly share code, notes, and snippets.

@knowtheory
Created January 30, 2009 17:32
Show Gist options
  • Select an option

  • Save knowtheory/55152 to your computer and use it in GitHub Desktop.

Select an option

Save knowtheory/55152 to your computer and use it in GitHub Desktop.
>> Member.new(Member.first(:id => "400001").attributes).valid?
~ (0.001096) SELECT "id", "name", "birthday", "gender", "osid", "bioguide", "metavidid", "state", "district" FROM "members" WHERE ("id" = '400001') ORDER BY "id" LIMIT 1
=> true
>> Member.new(Member.first(:id => "400001").attributes).save
~ (0.000888) SELECT "id", "name", "birthday", "gender", "osid", "bioguide", "metavidid", "state", "district" FROM "members" WHERE ("id" = '400001') ORDER BY "id" LIMIT 1
~ (0.000379) INSERT INTO "members" ("bioguide", "birthday", "state", "gender", "district", "name", "osid", "id") VALUES ('A000014', '1938-06-26', 'HI', 'M', 1, 'Rep. Neil Abercrombie [D, HI-1]', 'N00007665', '400001')
~ (sql_state=23505) ERROR: duplicate key value violates unique constraint "members_pkey"
Query: INSERT INTO "members" ("bioguide", "birthday", "state", "gender", "district", "name", "osid", "id") VALUES ('A000014', '1938-06-26', 'HI', 'M', 1, 'Rep. Neil Abercrombie [D, HI-1]', 'N00007665', '400001')
PostgresError: (sql_state=23505) ERROR: duplicate key value violates unique constraint "members_pkey"
Query: INSERT INTO "members" ("bioguide", "birthday", "state", "gender", "district", "name", "osid", "id") VALUES ('A000014', '1938-06-26', 'HI', 'M', 1, 'Rep. Neil Abercrombie [D, HI-1]', 'N00007665', '400001')
from /Library/Ruby/Gems/1.8/gems/dm-core-0.9.10/lib/dm-core/adapters/data_objects_adapter.rb:92:in `execute_non_query'
from /Library/Ruby/Gems/1.8/gems/dm-core-0.9.10/lib/dm-core/adapters/data_objects_adapter.rb:92:in `execute'
from /Library/Ruby/Gems/1.8/gems/dm-core-0.9.10/lib/dm-core/adapters/data_objects_adapter.rb:173:in `with_connection'
from /Library/Ruby/Gems/1.8/gems/dm-core-0.9.10/lib/dm-core/adapters/data_objects_adapter.rb:90:in `execute'
from /Library/Ruby/Gems/1.8/gems/dm-core-0.9.10/lib/dm-core/adapters/data_objects_adapter.rb:26:in `create'
from /Library/Ruby/Gems/1.8/gems/dm-core-0.9.10/lib/dm-core/adapters/data_objects_adapter.rb:15:in `each'
from /Library/Ruby/Gems/1.8/gems/dm-core-0.9.10/lib/dm-core/adapters/data_objects_adapter.rb:15:in `create'
from /Library/Ruby/Gems/1.8/gems/dm-core-0.9.10/lib/dm-core/repository.rb:51:in `create'
from /Library/Ruby/Gems/1.8/gems/dm-core-0.9.10/lib/dm-core/resource.rb:574:in `hookable__create_nan_before_advised'
from /Library/Ruby/Gems/1.8/gems/extlib-0.9.11/lib/extlib/hook.rb:294:in `create'
from /Library/Ruby/Gems/1.8/gems/extlib-0.9.11/lib/extlib/hook.rb:292:in `catch'
from /Library/Ruby/Gems/1.8/gems/extlib-0.9.11/lib/extlib/hook.rb:292:in `create'
from /Library/Ruby/Gems/1.8/gems/dm-core-0.9.10/lib/dm-core/resource.rb:280:in `hookable__save_nan_before_advised'
from /Library/Ruby/Gems/1.8/gems/extlib-0.9.11/lib/extlib/hook.rb:294:in `save'
from /Library/Ruby/Gems/1.8/gems/extlib-0.9.11/lib/extlib/hook.rb:292:in `catch'
from /Library/Ruby/Gems/1.8/gems/extlib-0.9.11/lib/extlib/hook.rb:292:in `save'
from (irb):7
from :0>>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment