Am 24.01.2011 14:08, schrieb Bart Joosen:
I think this is a problem with quotes.
If you look good, you see:
seiz.df<- sqlFetch(chnl, 'source.MAIN')
... 'source.main': table not found on channel
You asked "MAIN", but your db can't find "main".
If you use seiz.df<- sqlFetch(chnl, '\"source\".\"MAIN\"') , you problem
should be gone.
I think the deeper problem lies with upper/lower case in the table name
- is it MAIN, Main or main? If a tablename in PostgreSQL has at least
one upper case, PostgreSQL uses quotes, and therefore the solution
proposed above applies...
HTH,
Albin
--
| Albin Blaschka, Mag.rer.nat.
| Etrichstrasse 26, A-5020 Salzburg
| * www.albinblaschka.info * www.thinkanimal.info *
| - It's hard to live in the mountains, hard but not hopeless!
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
