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

Yes the table does have a primary key defined.

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

-------------- Original message ----------------------
From: "Ken Allen" <KenA@[EMAIL PROTECTED]
>
> 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.
>=20

Does the table with the OID have a primary key defined?


--
Adrian Klaver
aklaver@[EMAIL PROTECTED]
 message has been scanned by MailScanner


--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general