Skip to content
This repository has been archived by the owner on Dec 8, 2022. It is now read-only.

Foreign key constrain violation on deleting data with shapes on PostgreSQL #56

Closed
laurentg opened this issue Dec 16, 2016 · 0 comments
Closed
Labels

Comments

@laurentg
Copy link
Contributor

$ gtfsdbloader postgresql://gtfs@localhost/gtfs --delete
...
sqlalchemy.exc.IntegrityError: (psycopg2.IntegrityError) update or delete on table "shapes" violates foreign key constraint "trips_feed_id_fkey2" on table "trips"
DETAIL:  Key (feed_id, shape_id)=(, 24) is still referenced from table "trips".
 [SQL: 'DELETE FROM shapes WHERE shapes.feed_id = %(feed_id_1)s'] [parameters: {'feed_id_1': ''}]
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Projects
None yet
Development

No branches or pull requests

1 participant