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

From Ken Allen
Subject Re: Cannot update table with OID with linked server in SQl Server
Date
Msg-id 840AD183D768624E9544DBE25573104201CDB4DB@nawd103067.barrett.com
Whole thread Raw
In response to Re: Cannot update table with OID with linked server in SQl Server  (aklaver@comcast.net (Adrian Klaver))
List pgsql-general
Yes the table does have a primary key defined.

-----Original Message-----
From: Adrian Klaver [mailto:aklaver@comcast.net]
Sent: Tuesday, May 06, 2008 7:07 PM
To: Ken Allen; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Cannot update table with OID with linked server
in SQl Server

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




--
This message has been scanned by MailScanner


pgsql-general by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Custom Base Type in C
Next
From: Luca Ferrari
Date:
Subject: regexp_replace in two times?