в MSSQL Добавил линкнутый сервер postgresql 8.2.

такой селект не работает:
select * from PGDBC.m.public.anchors;

такой работает:

select * from openquery(PGDBC,'select * from anchors;');


Такой insert не рабоатет:
insert into PGDBC.m.[public].anchors(anchor_stamp) values(0);
----------------
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "PGDBC" reported an error. The provider did not give any information about the error.
Msg 7343, Level 16, State 2, Line 1
The OLE DB provider "MSDASQL" for linked server "PGDBC" could not INSERT INTO table "[PGDBC].[m].[public].[anchors]". Unknown provider error.

drunk2

вы пробовали такой синтаксис?

так выбирает:
select * from openquery(PGDBC,'select anchor_stamp,anchor_stamp_2 from anchors;')

так не вставляет:
insert openquery(PGDBC,'select anchor_stamp,anchor_stamp_2 from anchors;') values(0,1)

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "PGDBC" reported an error. The provider did not give any information about the error.
Msg 7343, Level 16, State 2, Line 1
The OLE DB provider "MSDASQL" for linked server "PGDBC" could not INSERT INTO table "[MSDASQL]". Unknown provider error.