sqlpetr

sqlpetr copied to clipboard

Proposed fix for issue: Error: host must be a single element of type 'character'.

1

Unfortunately I ran into the error: Error: host must be a single element of type 'character'. This occurred in my install on R version 4.0.3, and Postgresql 11. I resolved...

reinout91

Error building Adventureworks docker image and connecting to postgres

9

I get an error when building a docker image. Because of the error, I also cannot connect to PostgreSQL. Code: ```r source(here("book-src", "restore-adventureworks-postgres-on-docker.R")) ``` Error: ``` Error response from daemon:...

larissawn

upgrade adventureworks provenance from MS source

2

1. Derive a Postgres restore image along the lines of `https://github.com/smithjd/sql-pet/blob/master/book-src/adventureworks.sql`. 2. decide whether to store the image in sql-pet or sqlpetr repositories 3. rewrite `sp_postgresql_functions.R` so that the image...

smithjd

This is part of the AdventureWorks porting - we have a working SQL Server container

znmeb

Add "connections" package to "DESCRIPTION"

1

znmeb

znmeb

swap adventureworks for dvdrental

1

replace functions associated with dvdrental in `sp_docker_functions.R` and `sp_postgresql_functions.R` - sp_make_dvdrental_image - sp_fetch_dvdrental_autodoc

smithjd

Swap Postgres from version 10 to 11, updating the following lines in sp_docker_functions.R 

smithjd

znmeb

sp_get_postgres_connection error

11

I am at chapter 5.3 in the book and ran into an error when running this code: con

harryahlas