Skip site navigation (1) Skip section navigation (2)

Re: unixodbc - postgresql: broken pipes, malloc, ksqo and other errors

From: ckjmaner <ckjmaner(dot)14nfuc(at)mail(dot)webservertalk(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: unixodbc - postgresql: broken pipes, malloc, ksqo and other errors
Date: 2004-04-13 11:43:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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:
> 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.


Posted via
View this thread:

In response to

pgsql-odbc by date

Next:From: Jeff EckermannDate: 2004-04-13 13:43:37
Subject: Re: parameter to db function
Previous:From: Markus DonathDate: 2004-04-13 11:28:06
Subject: Re: ODBC driver further developments?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group