Bugs item #1010540, was opened at 2008-12-26 14:06
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010540&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Brian Feldman (brianfeldman)
Assigned to: Nobody (None)
Summary: invalid timestamp string generated for subseconds = 0

Initial Comment:
The timestamp string conversion contains a spurious "." with no trailing digits if the subseconds value is exactly 0. PostgreSQL cannot parse this. This would be an appropriate fix, I think, by removing the trailing "." as well if all the trailing "0" characters after it were removed.

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010540&group_id=1000125

That's the thing, I have unixODBC installed, it is located at /opt/local/bin that is why I need help figuring out how to get the terminal to recognize where both pg_config AND obdcinst are at during the ./configure process.
PATH=$PATH:/usr/local/pgsql/bin:/opt/local/bin should work but it's not recognizing the second part.....the odncinst part.

----- Original Message ----
From: Zoltan Boszormenyi
To: Brent Austin yahoo.com>
Cc: Jeremy Faith cemsys.com>; pgsql-odbc@postgresql.org
Sent: Monday, September 22, 2008 5:36:19 AM
Subject: Re: [ODBC] compiling odbc

Brent Austin írta:

I still get this:
client-66-1xx-1x-x14:~ brent1a$ PATH=$PATH:/usr/local/pgsql/bin:/opt/local/bin
client-66-1xx-1x-x14:~ brent1a$ cd /psqlodbc-08.03.0200
client-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configure
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... no
checking for mawk... no
checking for nawk... no
checking for awk... awk
checking whether make sets $(MAKE)... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for pg_config... /usr/local/pgsql/bin/pg_config
checking for gcc... gcc
...........
checking how to hardcode library paths into programs... immediate
checking for library containing SQLGetPrivateProfileString... no
configure: error: unixODBC library...

Yes, two PATH items, I guess.
"export PATH=$PATH:/usr/local/pgsql"

takes care of:

"checking for pg_config... no
configure: error: pg_config not found (set PG_CONFIG environment variable)"

How can I take care of the following as well with out messing up the above?

"configure: error: unixODBC library "odbcinst" not found"

(I found "odbcinst" is in my /opt/local/bin)

----- Original Message ----
From: Tom Lane
To: Brent Austin yahoo.com>
Cc: Jeremy Faith cemsys.com>; pgsql-odbc@postgresql.org
Sent: Friday, September 19, 2008 3:11:36 PM
Subject: Re: [ODBC] compiling odbc

Brent Austin yahoo.com> writes:

Two PATH items?

            regards, tom lane

I got export PATH=$PATH:/usr/local/pgsql to work

but now I get:
"configure: error: unixODBC library "odbcinst" not found"

I found that "odbcinst" is in my /opt/local/bin

How do I tell configure that pgsql is in /usr/local/pgsql and ALSO tell it that obcinst is in /opt/local/bin ???

----- Original Message ----
From: Jeremy Faith cemsys.com>
To: pgsql-odbc@postgresql.org
Sent: Friday, September 19, 2008 6:35:23 AM
Subject: Re: [ODBC] compiling odbc

Hi,

Brent Austin wrote:

So far this is what I get when I try that command-

client-66-1xx-17-xx4:~ brent1a$ export PATH=$PATH:/usr/local/psql/bin
client-66-1xx-17-xx4:~ brent1a$ cd /psqlodbc-08.03.0200
client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ sudo ./configure
Password:
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... no
checking for mawk... no
checking for nawk... no
checking for awk... awk
checking whether make sets $(MAKE)... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for pg_config... no
configure: error: pg_config not found (set PG_CONFIG environment variable)
client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$

My pg_config file is in: /usr/local/pgsql/bin so how do I tell terminal to see that it's there instead of where it thinks it is?

----- Original Message ----
From: Brent Austin yahoo.com>
To: pgsql-odbc@postgresql.org
Sent: Thursday, September 18, 2008 2:15:07 PM
Subject: Re: [ODBC] compiling odbc

I just installed the latest Postgres from source so everything needed should be there. Some of the things I've been installing recently have not had the right PATH but I thought I fixed that. What would fix this problem?
I think postgres is installed in:
/usr/local/psql

would this fix it:
export PATH=$PATH:/usr/local/psql
or maybe
echo "export PATH=\"/usr/local/psql:$PATH\"" >>.bash_profile

----- Original Message ----
From: Tom Lane
To: Brent Austin yahoo.com>
Cc: pgsql-odbc@postgresql.org
Sent: Thursday, September 18, 2008 1:52:00 PM
Subject: Re: [ODBC] compiling odbc

I just installed the latest Postgres from source so everything needed should be there. Some of the things I've been installing recently have not had the right PATH but I thought I fixed that. What would fix this problem?
I think postgres is installed in:
/usr/local/psql

would this fix it:
export PATH=$PATH:/usr/local/psql
or maybe
echo "export PATH=\"/usr/local/psql:$PATH\"" >>.bash_profile

----- Original Message ----
From: Tom Lane
To: Brent Austin yahoo.com>
Cc: pgsql-odbc@postgresql.org
Sent: Thursday, September 18, 2008 1:52:00 PM
Subject: Re: [ODBC] compiling odbc

Brent Austin yahoo.com> writes:

I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.
Here is what I get:
client-66-xxx-17-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configure
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... no
checking for mawk... no
checking for nawk... no
checking for awk... awk
checking whether make sets $(MAKE)... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for pg_config... no
configure: error: pg_config not found (set PG_CONFIG environment variable)

How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"
(I'm relatively new to most of this?
thanks
-B

I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.Here is what I get:client-66-xxx-17-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configurechecking for a BSD-compatible install... /usr/bin/install -cchecking whether build environment is sane... yeschecking for gawk... nochecking for mawk... nochecking for nawk... nochecking for awk... awkchecking whether make sets $(MAKE)... yeschecking whether to enable maintainer-specific portions of Makefiles... nochecking for pg_config... noconfigure: error:
pg_config not found (set PG_CONFIG environment variable)How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"(I'm relatively new to most of this?thanks-B

Hi,
I%%u2019ve detected problem with using psqlodbc driver on Sun Sparc Solaris platform.
An error occurs when Sparc converts unsigned short to unsigned int and back to unsigned short.
With default implementation 00 00 01 02 is converted to 00 00 (last two bytes are skipped), but it should be converted to 01 and 02.
Problem occurs every time when through method SOCK_put_int two bytes integer was transferred and doesn%%u2019t allow using PGAPI_PutData (odbc_lo_write) to put large objects to database.

To resolve described problem I%%u2019ve attached patch bellow.

Regards
Marcin