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

From: aklaver(at)comcast(dot)net (Adrian Klaver)
To: "Ken Allen" <KenA(at)BarrettXplore(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cannot update table with OID with linked server in SQl Server
Date: 2008-05-06 22:07:15
Message-ID: 050620082207.20385.4820D69300073D1A00004FA122058861729D0A900E04050E@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-------------- Original message ----------------------
From: "Ken Allen" <KenA(at)BarrettXplore(dot)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(at)comcast(dot)net

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-05-06 22:19:20 Re: [GENERAL] psql \pset pager
Previous Message Alex Vinogradovs 2008-05-06 21:46:40 Re: xlogdump & pgview