First time playing around with GTFS, so potentially may be making an obvious mistake. I previously had gtfsrdb + gtfsrdb working with SQLITE, but can't get the same to work with postgres.
I'm using the following configuration string:
./gtfsrdb.py -t https://gtfsrt.api.translink.com.au/Feed/SEQ -p https://gtfsrt.api.translink.com.au/Feed/SEQ -a https://gtfsrt.api.translink.com.au/Feed/SEQ -d postgresql://username:password@localhost:5432/translink -c -o
The error I'm receiving is:
Adding 3575 trip updates Exception occurred in iteration (<class 'sqlalchemy.exc.DataError'>, DataError('(psycopg2.DataError) value too long for type character varying(10)\n',), <traceback object at 0x7f74086117e8>) Exception occurred in iteration
I tried updating the column lengths in postgres, but that didn't seem to work.
First time playing around with GTFS, so potentially may be making an obvious mistake. I previously had gtfsrdb + gtfsrdb working with SQLITE, but can't get the same to work with postgres.
I'm using the following configuration string:
./gtfsrdb.py -t https://gtfsrt.api.translink.com.au/Feed/SEQ -p https://gtfsrt.api.translink.com.au/Feed/SEQ -a https://gtfsrt.api.translink.com.au/Feed/SEQ -d postgresql://username:password@localhost:5432/translink -c -oThe error I'm receiving is:
Adding 3575 trip updates Exception occurred in iteration (<class 'sqlalchemy.exc.DataError'>, DataError('(psycopg2.DataError) value too long for type character varying(10)\n',), <traceback object at 0x7f74086117e8>) Exception occurred in iterationI tried updating the column lengths in postgres, but that didn't seem to work.Cheers