This will be fixed on Solaris in PostgreSQL release 7.4.3. ---------------------------------------------------------------------------
Wes Palmer wrote: > On 3/23/04 8:28 PM, "Bruce Momjian" <[EMAIL PROTECTED]> wrote: > > > 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. > > I posted a follow up, including a small sample program. The ecpg C code > output is identical on both Linux and Solaris. The problem exists all the > time - the error code is *never* set (at least never that I've seen). Sqlca > is always the same regardless of success or failure of the operation. The > reason it appeared valid operations didn't work is I was searching for the > wrong record, and since there's no error code set... > > Wes > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend