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

[Adrian Klaver]

-------------- Original message ----------------------
From: "Ken Allen" <[EMAIL PROTECTED]>
> 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
[EMAIL PROTECTED]

 

--- Begin Message ---

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 ---

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general