Re: Trigger updates MS SQL table

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: "Home (E-mail)" <don(at)sceifers(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Trigger updates MS SQL table
Date: 2003-09-15 19:56:58
Message-ID: 1063655818.20709.65.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-interfaces

IIRC some folks on -hackers are working on cross database queries to
interface with oracle databases, theres a chance that could work for sql
server too. Someone else on -hackers was looking at an internal soap/xml
communications method to do similar things to what your describing. You
might want to check the archives on both ideas.

The other option, and probably more doable, is to write a function in
one of the untrusted languages to communicate with your xml service via

Robert Treat

On Wed, 2003-09-10 at 15:29, Home (E-mail) wrote:
> Is it too presumptious that there should be a direction I can go to solve my
> problem.
> Right now, I have a postgres environment that our business is run on and SQL
> Server 2000 databases that our customer ASP solutions run in. Both serve
> their purposes well. So, I need both. What I was hoping, was to get a form
> of replication going between the two. In a perfect world, my trigger would
> just create an ODBC connection to the MS Sql server and run the
> update/insert query. I know that cannot exactly happen, it just doesn't work
> that way.
> But can I create a trigger that allows me to connect to a SOAP/XML service
> and deliver the update via a stored procedure call? Is this too much to hope
> for, or are people doing this already?
> Thanks
> Don Sceifers
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to


Browse pgsql-interfaces by date

  From Date Subject
Next Message Christoph Haller 2003-09-16 07:51:59 Re: ColumnName and ColumnNumber in libpq (C interface)
Previous Message Tom Lane 2003-09-15 14:48:47 Re: ColumnName and ColumnNumber in libpq (C interface)