Postgres Pro
Downloads
Home   >   mailing lists

Re: Cannot update table with OID with linked server in SQl Server - Mailing list pgsql-general

From aklaver@comcast.net (Adrian Klaver)
Subject Re: Cannot update table with OID with linked server in SQl Server
Date
Msg-id 050620082207.20385.4820D69300073D1A00004FA122058861729D0A900E04050E@comcast.net
Whole thread Raw
In response to Cannot update table with OID with linked server in SQl Server  ("Ken Allen" <KenA@BarrettXplore.com>)
List pgsql-general
Tree view 
-------------- Original message ----------------------
From: "Ken Allen" <KenA@BarrettXplore.com>
> 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@comcast.net

pgsql-general by date:

Previous
From: Alex Vinogradovs
Date:
Subject: Re: xlogdump & pgview
Next
From: Klint Gore
Date:
Subject: Re: Is this possible in a trigger?