Skip to content
Prev 509 / 1559 Next

errors using the field.types arg in dbBuildTableDefinition() for RPostgreSQL

Well, here is the problem:
All the above calls to dbBuildTableDefinition give the following error:

Error in function (classes, fdef, mtable)  :
  unable to find an inherited method for function "make.db.names", for
signature "PostgreSQLConnection", "NULL"

But this works, albeit forcing the bigint type:
[1] "CREATE TABLE tmp_vidtable \n( x bigint,\n\ty bigint \n)"
                                                       ^             ^^
OK, this is a petty issue: the above SQL statement is not "indented"
correctly :)

Getting back, ?dbBuildTableDefinition shows the following:

field.types   optional named list of the types for each field in obj

Am I interpreting it wrongly?

Thanks.
--
PK