If I had to take a guess, there is something wrong with the ecpg program
and the error is masked on Linux, but is visible on Solaris. I would
break the program down into small parts and test to see where there
error starts.
---------------------------------------------------------------------------
wespvp@syntegra.com wrote:
> I have an ecpg program that runs perfectly on Linux (PostgreSQL 7.4.1). I
> recompile it on Solaris and when I try to run it the results are total
> gibberish. When I connect:
>
> EXEC SQL WHENEVER SQLERROR GOTO sql_error;
> EXEC SQL CONNECT TO :dbTarget USER :user USING :pw;
>
> Where dbTarget = mydb@host.my.domain
> user = xxxuser
> pw = xxxpassword
>
> The GOTO is not taken and sqlca.sqlcode is set to 0 (no error).
>
> Similarly, when I try to fetch records, either using SELECT or with a
> DECLARE CURSOR/FETCH, I get no records and sqlcl.sqlcode is zero (no error).
> Since I get no record, but no error is detected, the variables are garbage
> and the program SEGV's trying to manipulate the variables.
>
> The above problems occur whether I use valid information for host/user/pw,
> or put in totally bogus values. Again, the program works perfectly on
> Linux.
>
> Psql works, and handles errors properly. Yet here, nothing works but no
> error codes are set.
>
> Any ideas what could be going on? Is ecpg broken on Solaris? Since psql
> works, it would seem that the build is valid.
>
> Wes
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073