search

safety-analytics-mapping / pysqldb3

Python3 version of pysqldb portion of ris library
1 stars 1 forks source link

Citext backup table test #95

Closed cindyatnycdot closed 5 days ago

cindyatnycdot commented 6 days ago

Added a test. I noticed that all the MS tests were also failing for me now due to the "text"-type columns; not sure if this is also failing for you.

cindyatnycdot commented 6 days ago

My MS tests are passing now but the one PG test with citext type columns isn't. The error I get is that it doesn't recognize 'citext' columns (even though I can create citext column tables in ris3 in PgAdmin). I saw online that I should run CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA working; before running the query, but I don't have user authorization to do so.

shostetter commented 5 days ago

@cindyatnycdot this is good to merge now, right?