pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedTrigger updates MS SQL table
3+ messages / 3 participants
[nested] [flat]
* Trigger updates MS SQL table
@ 2003-09-10 19:29 Home (E-mail) <don@sceifers.com>
2003-09-15 19:56 ` Re: Trigger updates MS SQL table Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 1 reply; 3+ messages in thread
From: Home (E-mail) @ 2003-09-10 19:29 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Trigger updates MS SQL table
2003-09-10 19:29 Trigger updates MS SQL table Home (E-mail) <don@sceifers.com>
@ 2003-09-15 19:56 ` Robert Treat <xzilla@users.sourceforge.net>
2003-09-16 20:42 ` Re: Trigger updates MS SQL table Jim Buttafuoco <jim@contactbda.com>
0 siblings, 1 reply; 3+ messages in thread
From: Robert Treat @ 2003-09-15 19:56 UTC (permalink / raw)
To: Home (E-mail) <don@sceifers.com>; +Cc: 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
sockets.
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Trigger updates MS SQL table
2003-09-10 19:29 Trigger updates MS SQL table Home (E-mail) <don@sceifers.com>
2003-09-15 19:56 ` Re: Trigger updates MS SQL table Robert Treat <xzilla@users.sourceforge.net>
@ 2003-09-16 20:42 ` Jim Buttafuoco <jim@contactbda.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jim Buttafuoco @ 2003-09-16 20:42 UTC (permalink / raw)
To: Robert Treat <xzilla@users.sourceforge.net>; Home (E-mail) <don@sceifers.com>; +Cc: pgsql-interfaces
Have you tried plperlu. I currently am using DBI (DBD::Pg and DBD::Oracle) to connect to external databases under PG
V7.2.4. While you can't use plperlu as your trigger language you call call it from your plpgsql.
Also note, I am only doing selects in my functions, so I don't have to worry about 2 phase commits and all the other
problems that go along with it.
Jim
---------- Original Message -----------
From: Robert Treat <xzilla@users.sourceforge.net>
To: "Home (E-mail)" <don@sceifers.com>
Cc: pgsql-interfaces@postgresql.org
Sent: 15 Sep 2003 15:56:58 -0400
Subject: Re: [INTERFACES] Trigger updates MS SQL table
> 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
> sockets.
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
------- End of Original Message -------
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-09-16 20:42 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-09-10 19:29 Trigger updates MS SQL table Home (E-mail) <don@sceifers.com>
2003-09-15 19:56 ` Robert Treat <xzilla@users.sourceforge.net>
2003-09-16 20:42 ` Jim Buttafuoco <jim@contactbda.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox