unrecognized PostgreSQL field type uuid (id:2950)

[koseri]

Connecting to a table with field type uuid generates a warning.

Table creation

CREATE TABLE prd_tv_sandbox.r_gender
(
respid UUID,
wave_id UUID,
gender INTEGER,
PRIMARY KEY (respid,wave_id)
);

# The R:

library (RPostgres)
library ( dplyr)
library ( DBI )


con_sb <- src_postgres(dbname = "the_db",   user = "[id]", password = "***")

gen_db <-  tbl ( con_sb, "r_gender" )

Warning messages:
1: In postgresqlExecStatement(conn, statement, ...) :
RS-DBI driver warning: (unrecognized PostgreSQL field type uuid (id:2950) in column 0)
2: In postgresqlExecStatement(conn, statement, ...) :
RS-DBI driver warning: (unrecognized PostgreSQL field type uuid (id:2950) in column 1)

[koseri]

BTW, if you don't have any UUIDs handy, Postgres will be glad to make them for you.

CREATE TABLE fuutab
(
fuu UUID DEFAULT uuid_generate_v4(),
name VARCHAR(255) NOT NULL
);

[alexfun]

Is this a problem? R doesn't have any default data types to handle uuids... I am guessing it gets converted to character().

[koseri]

It is indeed character data in R. However, as soon as you connect to or use a table with Postgres field type UUID, the driver starts throwing warnings. Incessant warnings over nothing are undesirable.

[alexfun]

But for other cases the warning is helpful. E.g. if you have the citext (case insensitive text) plug-in installed, then you have to be careful writing and downloading data from case insensitive columns.

[koseri]

The idea would be to throw warnings only for truly unrecognized types.

[Andrei-Pozolotin]

+1

[abhoffman]

+1

[thoughtfuldata]

+1

[EmteZogaf]

+1

[JackStat]

Can someone review the pull request #55 and merge or make recommendations for modifications? I just want the changes to be fresh if there is a discussion to be had and it seems like people would like to see a fix added.

[krlmlr]

Done. For now there's devtools::install_github("rstats-db/RPostgres#55")

[github-actions]

This old thread has been automatically locked. If you think you have found something related to this, please open a new issue and link to this old issue if necessary.