ices-eg / wg_WGEEL

Joint EIFAAC/ICES/GFCM Working Group on Eels
http://ices.dk/community/groups/Pages/WGEEL.aspx
5 stars 16 forks source link

Test / develop shiny data integration for new file format #131

Closed cedricbriandgithub closed 4 years ago

cedricbriandgithub commented 4 years ago

The new formatting may require some adaptation of the code for initial load. Check that it works for

cedricbriandgithub commented 4 years ago

There is a bug in pool upon entering the password

Warning in postgresqlExecStatement(conn, statement, ...) :
  RS-DBI driver warning: (unrecognized PostgreSQL field type geometry (id:3556157) in column 13)
Warning in postgresqlExecStatement(conn, statement, ...) :
  RS-DBI driver warning: (unrecognized PostgreSQL field type geometry (id:3556157) in column 3)
Warning: Error in <Anonymous>: unable to find an inherited method for function 'dbQuoteLiteral' for signature '"Pool"'
  84: stop
  83: <Anonymous>
  82: DBI::dbQuoteLiteral
  81: .transformer
  80: <Anonymous>
Warning: Error in <Anonymous>: unable to find an inherited method for function 'dbQuoteLiteral' for signature '"Pool"'
  84: stop
  83: <Anonymous>
  82: DBI::dbQuoteLiteral
  81: .transformer
  80: <Anonymous>

The bug is there, https://github.com/rstudio/pool/issues/96. It's a problem with packages glue and pool.
It is solved by using either 3.6.1 or 3.4.2 version of R
elfunesto commented 4 years ago

Seems ok