X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DB32053DCA for ; Tue, 8 Mar 2005 04:48:48 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35162-09 for ; Tue, 8 Mar 2005 04:48:40 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id 23DD956545 for ; Tue, 8 Mar 2005 04:48:39 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 923DC319CE; Tue, 8 Mar 2005 05:48:39 +0100 (MET) From: "Igor Kryltsov" X-Newsgroups: pgsql.sql Subject: Update PostgreSQL from MS SQL trigger Date: Tue, 8 Mar 2005 15:47:57 +1100 Organization: Hub.Org Networking Services Lines: 16 Message-ID: X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.462 tagged_above=0 required=5 tests=AWL, FORGED_YAHOO_RCVD, PRIORITY_NO_NAME X-Spam-Level: *** X-Archive-Number: 200503/175 X-Sequence-Number: 20655 Hi, I have table 'test_m'(id integer) in MSSQL and I want to write on_test_m_insert trigger in MS SQL which will insert value into PostgreSQL table 'test_p' from database 'test_db' running on host '10.3.2.5'. Can this be achieved with PostgreSQL ODBC driver? If yes, please post template of such trigger. Thank you, Igor