Urgen help required

From: "J S B" <jsbali(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Urgen help required
Date: 2006-10-18 08:05:40
Message-ID: a47902760610180105j1815f36cyfd996accf0e1cb62@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I have the following scenario:-

1. There's a function in the postgres datbase that when executed calls a
shared object (dynamically loaded).
2. The shared object is a Client (made using socket library) which connects
to a server (coded again using socket library) hosted on some other machine.
3. This server when invoked through the postgres function described above
has an ECPG code in it that gets executed after a successful write back to
the client, which inserts a record in a table in the postgres database.

I use ECPGdebug in the begening of the server code file to see the state of
affairs with the ECPG code and it always raises -402 sqlcode which means the
connection attempt to the database did not succeed.

All firewalls in the datbase server and this machine wherein my socket
server is running are disabled.
Other function calls from this machine to my database machine are working
fine.

Also, my postgres function is able to establish connection with the this
outside deamon (that i refer to as server coded using socket library).
Just the ECPG calls from this deamon back to postgres database are not
successful.

Any kind of help would be highly appreciated.

Thanks,
Jas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2006-10-18 08:08:26 Re: help with sql query
Previous Message Albe Laurenz 2006-10-18 07:53:49 Re: [HACKERS] query log corrupted-looking entries