Support for PostgreSQL 8.1.3 stable

Hi,

like to check if psqlodbc-08.01.0200 can work with PostgreSQL 8.1.3?

I had compiled and installed psqlodbc on OpenBSD 3.8, but was unable to
connect with isql. The Driver Manager is unixODBC-2.2.11 from source and
PGSQL was installed from source as well. There was no error of warning
when I run isql, the program just exit and return to the shell prompt.

I tried with PGSQL 8.0.7 installed from OpenBSD packages, and was able
to connect and query the db. Thus, I seek confirmation/verification on
8.1.3 support. Appreciate any advice. Thanks.

Regards,
Andrew Ng
--=20
Andrew Ng
ngandrew@fastmail.fm

--=20
http://www.fastmail.fm - And now for something completely different=85


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Support for PostgreSQL 8.1.3 stable

I'm sorry for late response at firest.

> like to check if psqlodbc-08.01.0200 can work with PostgreSQL 8.1.3?

Yes it can. I see no problem with this combination.

> I had compiled and installed psqlodbc on OpenBSD 3.8, but was unable to
> connect with isql. The Driver Manager is unixODBC-2.2.11 from source and
> PGSQL was installed from source as well. There was no error of warning
> when I run isql, the program just exit and return to the shell prompt.
>
> I tried with PGSQL 8.0.7 installed from OpenBSD packages, and was able
> to connect and query the db. Thus, I seek confirmation/verification on
> 8.1.3 support. Appreciate any advice. Thanks.

Are you able to produce some mylog output with psqlodbc 08.01.0200?

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: Support for PostgreSQL 8.1.3 stable

Hi Luf,

only saw your below reply from archive, must have deleted original
message inadvertently :)

I can't find instructions on how to enable mylog and where the output is
save to, please provide any reference or steps. Thanks.

Regards

------------------------------------------------------------ ---------------=
---------------------
I'm sorry for late response at firest.

> like to check if psqlodbc-08.01.0200 can work with PostgreSQL 8.1.3?

Yes it can. I see no problem with this combination.

> I had compiled and installed psqlodbc on OpenBSD 3.8, but was unable to
> connect with isql. The Driver Manager is unixODBC-2.2.11 from source and
> PGSQL was installed from source as well. There was no error of warning
> when I run isql, the program just exit and return to the shell prompt.

> I tried with PGSQL 8.0.7 installed from OpenBSD packages, and was able
> to connect and query the db. Thus, I seek confirmation/verification on
> 8.1.3 support. Appreciate any advice. Thanks.

Are you able to produce some mylog output with psqlodbc 08.01.0200?

Regards,

Luf
------------------------------------------------------------ ---------------=
---------
--=20
Andrew Ng
ngandrew@fastmail.fm

--=20
http://www.fastmail.fm - And now for something completely different=85


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: Support for PostgreSQL 8.1.3 stable

> The only odbc.ini in my system is at /usr/local/etc/odbc.ini. If I'm not
> wrong, it's for unixODBC configurations. Do you mind posting the file
> location and content(with confidential data obfuscated)?

I don't know maybe someone here could see the problem. I have zero
knowledge about *BSD systems so maybe problem could be there. If I have
same problem I'll try strace to see what happens.
The odbc.ini location depends on configure parameters for unixODBC.

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: Support for PostgreSQL 8.1.3 stable

Thanks, will check on strace.

On Wed, 26 Apr 2006 15:11:13 +0200, "Ludek Finstrle"
said:
> > The only odbc.ini in my system is at /usr/local/etc/odbc.ini. If I'm not
> > wrong, it's for unixODBC configurations. Do you mind posting the file
> > location and content(with confidential data obfuscated)?
>
> I don't know maybe someone here could see the problem. I have zero
> knowledge about *BSD systems so maybe problem could be there. If I have
> same problem I'll try strace to see what happens.
> The odbc.ini location depends on configure parameters for unixODBC.
>
> Regards,
>
> Luf
--
Andrew Ng
ngandrew@fastmail.fm

--
http://www.fastmail.fm - I mean, what is it about a decent email service?


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org