agency_id is required

[flibbertigibbet]

If optional GTFS field agency_id is missing, receive error:

ERROR: null value in column "agency_id" violates not-null constraint

Can reproduce with Chicago GTFS.

[echeipesh]

Yes, as you say that field is optional for GTFS systems that only apply to a single agency. That implies the field is nullable. Would it present a problem to have the schema reflect that ?

[flibbertigibbet]

I don't think we're using the agency_id field at all at this point, so no. It may be easier to just assign some default value there; it doesn't matter what it is.