public-transport/gtfs-via-postgres

`valid_default_lang` error with languages like "DE"

Open

#32 opened on Dec 28, 2022

View on GitHub
 (3 comments) (0 reactions) (0 assignees)JavaScript (21 forks)github user discovery
bughelp wanted

Repository metrics

Stars
 (141 stars)
PR merge metrics
 (PR metrics pending)

Description

ERROR: new row for relation "feed_info" violates check constraint "valid_default_lang"

Was fixed by changing feed_lang from en to en_US.utf8 but en seems to be used in the example amtrak GTFS and in BART.

Contributor guide

Research direction
Inspect the valid default lang constraint in the database schema and understand how feed lang values are validated. Check the GTFS standard for language codes and consider adding support for two letter codes or allowing alternative formats.
Tech stack
javascriptpostgresqlsql
Domain
backenddatabasedata
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
PostgreSQLSQLGTFS
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
75