Skip to content

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

2 messages · Prasenjit Kapat

#
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
#
Ignore my earlier mail on this subject. Sorry for spamming.
On Thu, Nov 6, 2008 at 6:59 PM, Prasenjit Kapat <kapatp at gmail.com> wrote:
Yes I did! It is a "named-list" and not a character vector :((