Skip to content

Instantly share code, notes, and snippets.

@ferbncode
Created July 19, 2017 10:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ferbncode/23f88c267dd26836438784adfa39752c to your computer and use it in GitHub Desktop.
Save ferbncode/23f88c267dd26836438784adfa39752c to your computer and use it in GitHub Desktop.
error
Error at statement:
INSERT INTO place (address, area, begin_date_day, begin_date_month, begin_date_year, comment, coordinates, edits_pending, end_date_day, end_date_month, end_date_year, ended, gid, id, last_updated, name, type) VALUES
('Verkatehtaankuja 7, FI-13200 Hämeenlinna, Finland', 9598, NULL, NULL, 2009, '', '(60.997758,24.477142)', 0, NULL, NULL, NULL, '0', 'd71ffe38-5eaf-426b-9a2e-e1f21bc84609', 955, '2013-11-08 19:31:00.585275+00', 'Suisto', 2)
(IntegrityError) insert or update on table "place" violates foreign key constraint "place_fk_type"
DETAIL: Key (type)=(2) is not present in table "place_type".
"\n\nINSERT INTO place (address, area, begin_date_day, begin_date_month, begin_date_year, comment, coordinates, edits_pending, end_date_day, end_date_month, end_date_year, ended, gid, id, last_updated, name, type) VALUES\n\t('Verkatehtaankuja 7, FI-13200 Hämeenlinna, Finland', 9598, NULL, NULL, 2009, '', '(60.997758,24.477142)', 0, NULL, NULL, NULL, '0', 'd71ffe38-5eaf-426b-9a2e-e1f21bc84609', 955, '2013-11-08 19:31:00.585275+00', 'Suisto', 2)" {}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment