Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux