Re: unixodbc - postgresql: broken pipes, malloc, ksqo and other errors - Mailing list pgsql-odbc

Duane Winner wrote:
> *Hello all. I am posting this on unixodbc-dev and pgsql-odbc as well
> as
> r-help to make sure all of my bases are covered (and because I'm not
> sure which one of these is the source of the issue.)
>
> Unixodbc with Postgresql seems to be working, but I am getting some
> errors that I don't understand and want to know why I am getting
> these
> errors before I put everything into production.
>
> I am running:
> FreeBSD 4.9-RELEASE
> unixODBC-2.2.8 (installed from FreeBSD port)
> postgresql-7.3.5_1 (installed from FreeBSD port)
> R 1.8.1 (installed from R-letter FreeBSD port)
> RODBC (installed from CRAN)
>
> Here is what is happening:
>
> When I run "isql":
> # isql mydb -v
> +---------------------------------------+
> | Connected!                            |
> |                                       |
> | sql-statement                         |
> | help [tablename]                      |
> | quit                                  |
> |                                       |
> +---------------------------------------+
> SQL> q
> Broken pipe
>
> *** Why am I getting "broken pipe"? What does it mean and does it
> matter?
>
>
> Also in R:
> > library(RODBC)
> > channel <- odbcConnect("mydb")
> > weather <-sqlQuery(channel,"select * from weather")
> > odbcClose(channel)
> R.bin in free(): warning: chunk is already free
>
> *** Why am I getting this warning? This one concerns me the most, as
> I
> need to make sure that it doesn't cause problems on a production
> system.
> I don't understand much about programming, but I have been told that
> this is essentially a 'malloc' error.
>
>
> Also, in ANY application (isql, OpenOffice, R) that opens a
> connection
> using unixODBC, I see in my postgresql log this message:
>
> ERROR:  'ksqo' is not a valid option name
>
> *** Why am I getting this error, and again, should I be concerned?
> Google actually gave me some results on this one, and to the best of
> my
> discerning, it looks as if it is some Microsoft query option that
> just
> isn't supported, in which case, fine. I'm just looking for
> assurances.
>
>
> Again, like I said, I am able to run queries and utilize unixodbc
> and
> the postgresql driver as best as I can tell. But I would hate to
> implement this into production and find out that there is some
> critical
> problem that will bite me once the production apps start to take
> some
> hits.
>
> Thanks for any info/assistance/guidance you can provide.
>
> -DW
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings *

Hello.  I am running the same setup as you, with the exception that I'm
running PostgreSQL 7.4.2.  However, I have been completely unsuccessful
at installing RODBC.  My unixODBC is working just fine in that I can
browse my tables using DataManager as well as isql from both root and
my user account(s).  I have read that one needs to set LIBS to
-L/usr/local/lib but that did not work either.  Any suggestions such as
configuration(s), path var settings, etc?  Any help you could lend
would really be appreciated.

Thanks,
Charles



--
ckjmaner
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message142704.html