Cannot update table with OID with linked server in SQl Server
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.
-------------- 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
Import Notes
Resolved by subject fallback
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