unrecognized PostgreSQL field type uuid (id:2950)

[r-dbi]

unrecognized PostgreSQL field type uuid (id:2950)

[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.

[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().

[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")

[jnolis]

This issue was closed a long time ago, yet somehow I am still seeing this error.

con <- DBI::dbConnect(RPostgreSQL::PostgreSQL(),
                 dbname =  "postgres",
                 port = 5432,
                 host = "127.0.0.1",
                 user = "postgres",
                 password = password
  )
DBI::dbSendStatement(con,"CREATE TABLE test (id UUID DEFAULT uuid_generate_v4 ());")
DBI::dbGetQuery(con,"SELECT * FROM test")

Yields:

data frame with 0 columns and 0 rows
Warning message:
In postgresqlExecStatement(conn, statement, ...) :
  RS-DBI driver warning: (unrecognized PostgreSQL field type uuid (id:2950) in column 0)

Any idea why it might be showing up? Thank you!

(also I'm happy to make a new issue out of this or whatever is most convenient, rather than commenting on a super old issue).

[krlmlr]

The code refers to the {RPostgreSQL} package, this repo hosts the {RPostgres} package. Do you still see the error when using {RPostgres}?

[jnolis]

Nope no issue. Sorry I didn't realize they were two separate packages!

[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.