Re: Cannot update table with OID with linked server in SQl Server

[aklaver@xxxxxxxxxxx (Adrian Klaver)]

-------------- Original message ----------------------
From: "Ken Allen" <KenA@xxxxxxxxxxxxxxxxx>
> I have a linked server on SQL server 2005.  I can update or write to a
> table in Postgres that does not have a OID.  But the Table I have has an
> OID and I cannot write or update to that table.  Anyone have any ideas.
> 

Does the table with the OID have a primary key defined?


--
Adrian Klaver
aklaver@xxxxxxxxxxx

--- Begin Message ---

• To: <pgsql-general@xxxxxxxxxxxxxx>
• Subject: [GENERAL] Cannot update table with OID with linked server in SQl Server
• From: "Ken Allen" <KenA@xxxxxxxxxxxxxxxxx>
• Date: Tue, 6 May 2008 19:47:48 +0000

I have a linked server on SQL server 2005.  I can update or write to a table in Postgres that does not have a OID.  But the Table I have has an OID and I cannot write or update to that table.  Anyone have any ideas.

 

--- End Message ---