pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Update PostgreSQL from MS SQL trigger
2+ messages / 1 participants
[nested] [flat]

* Update PostgreSQL from MS SQL trigger
@ 2005-03-08 04:47 Igor Kryltsov <kryltsov@yahoo.com>
  2005-03-08 22:44 ` Re: Update PostgreSQL from MS SQL trigger Igor Kryltsov <kryltsov@yahoo.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Igor Kryltsov @ 2005-03-08 04:47 UTC (permalink / raw)
  To: pgsql-sql

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Update PostgreSQL from MS SQL trigger
  2005-03-08 04:47 Update PostgreSQL from MS SQL trigger Igor Kryltsov <kryltsov@yahoo.com>
@ 2005-03-08 22:44 ` Igor Kryltsov <kryltsov@yahoo.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Igor Kryltsov @ 2005-03-08 22:44 UTC (permalink / raw)
  To: pgsql-sql

I managed to link PostgreSQL to MSSQL as a linked server but:

select * from [TEST].[test].[public].[users] <<<TEST - name of linked server
in MSSQL , test - Postgres db name, public - schema name, users - table
Returns:
Server: Msg 7312, Level 16, State 1, Line 7
Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A
four-part name was supplied, but the provider does not expose the necessary
interfaces to use a catalog and/or schema.

Works only via OPENQUERY:

SELECT * FROM OPENQUERY (TEST, 'select * from users');


Does anybody know how to query Postgres WITHOUT OPENQUERY.

I found in groups that:

" According to the documentation, SQL-Server supports any Win32 ODBC
  driver ... which would include PostgresODBC.  However, in practice,
  only Microsoft-supplied drivers actually work; ODBC drivers for
  Postgres and MySQL mysteriously do not function with SQL-Server (even
  though they do work with MS Access).
 I think this is incompetence on Microsoft's part rather than malice;
  all of this works through DTS, a utility which is responsible for over
  300 Knowledge Base issues.
 Note:  I have not tried any of this with SQL Server 2000, just 7.0 sp3. "



Thank you,



Igor

"Igor Kryltsov" <kryltsov@yahoo.com> wrote in message
news:d0jar6$14rh$1@news.hub.org...
> 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
>
>





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2005-03-08 22:44 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-08 04:47 Update PostgreSQL from MS SQL trigger Igor Kryltsov <kryltsov@yahoo.com>
2005-03-08 22:44 ` Igor Kryltsov <kryltsov@yahoo.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