search

evdubs / nasdaq-symbols

ETL for the NASDAQ symbol file
Mozilla Public License 2.0
14 stars 4 forks source link

How to fix schema "nasdaq" does not exist #1

Closed liweijian closed 4 years ago

liweijian commented 4 years ago

Got error when runing sh extract-transform-load.sh , I was wondering if anything else I missed?

$ sh extract-transform-load.sh
query-exec: schema "nasdaq" does not exist
  SQLSTATE: 3F000
  context...:
   /Users/pltbuild/build/plt-release-cs-64/bundle/racket/collects/db/private/generic/interfaces.rkt:170:0: raise-sql-error
   /Users/pltbuild/build/plt-release-cs-64/bundle/racket/share/pkgs/db-lib/db/private/postgresql/connection.rkt:535:4: prepare1:collect method in connection-base%
   /opt/racket/pltbuild/racket/racket/collects/racket/private/more-scheme.rkt:261:28
   /Users/pltbuild/build/plt-release-cs-64/bundle/racket/collects/db/private/generic/common.rkt:277:13
   /Users/pltbuild/build/plt-release-cs-64/bundle/racket/collects/db/private/generic/../../../racket/private/more-scheme.rkt:261:28
   /Users/pltbuild/build/plt-release-cs-64/bundle/racket/collects/db/private/generic/functions.rkt:90:0: compose-statement
   /Users/pltbuild/build/plt-release-cs-64/bundle/racket/collects/db/private/generic/functions.rkt:148:0: query-exec
   /Users/tli/Downloads/nasdaq-symbols/transform-load.rkt:63:11
   /Users/pltbuild/build/plt-release-cs-64/bundle/racket/collects/racket/private/sequence.rkt:33:2: for-loop
   /Users/pltbuild/build/plt-release-cs-64/bundle/racket/collects/racket/private/sequence.rkt:30:0: sequence-for-each
   dynamic-wind
   proc
   body of "/Users/tli/Downloads/nasdaq-symbols/transform-load.rkt"
   temp37_0
   for-loop
   run-module-instance!125
evdubs commented 4 years ago

I assume you were able to create a nasdaq schema in your database?

liweijian commented 4 years ago

Spot on! I realized that might be I missed the comma at the end of the psql create command and close this issue immediately.