adilapapaya / rpostgresql

Automatically exported from code.google.com/p/rpostgresql
0 stars 0 forks source link

Incorrect Error Message #38

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?

1. Run Postgres with some data in a table

2. Do dbGetQuery("query").  The query should return some rows from a table.

3. Get a bad error message once for each select "unrecognized PostgreSQL field 
type void (id: 2278) in column 0.

What is the expected output? What do you see instead?
The error message should not be there.

What version of the product are you using? On what operating system?
Postgres 9.1.  Running Mac OSX Lion R 2.14.1

Please provide any additional information below.
Simple fix. Add the lines

case VOIDOID:
    break;

after line 546 in RS-PostgreSQL.c.

Basically column 0 on every select is of type void.

Original issue reported on code.google.com by ashwin.k...@gmail.com on 14 Jan 2012 at 2:56

GoogleCodeExporter commented 9 years ago
Thanks for the report.

However, this report was not reproducible, as the detail on the "some data" and 
"query" is not provided.  So far as tested, the iris dataset stored with 
dbWriteTable(), and "select * from iris" does not produce the above error on OS 
X 10.6.8 (R 2.14.0, RPostgreSQL installed from binary package) connected with 
9.1.2 server running on another machine.

The error message can be produced with
dbGetQuery(con,"select NULL::void")
However, in this case, the warning is reasonable as it is unclear how to handle
the void type.

So, I suspect that "query" is in fact a function that really returns a void 
type, for which we do not have determined what is the right way to handle.

Original comment by tomoa...@kenroku.kanazawa-u.ac.jp on 21 Jan 2012 at 9:29

GoogleCodeExporter commented 9 years ago
This is closed because no concrete way to reproduce the problem is provided.

Original comment by tomoa...@kenroku.kanazawa-u.ac.jp on 9 Oct 2012 at 9:27