--NextPart_Webmail_9m3u9jl4l_20385_1210111635_0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
-------------- 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.
>
Does the table with the OID have a primary key defined?
--
Adrian Klaver
aklaver@[EMAIL PROTECTED]
--NextPart_Webmail_9m3u9jl4l_20385_1210111635_0
Content-Type: message/rfc822
From: "Ken Allen" <KenA@[EMAIL PROTECTED]
>
To: <pgsql-general@[EMAIL PROTECTED]
>
Subject: [GENERAL] Cannot update table with OID with linked server in
SQl Server
Date: Tue, 6 May 2008 19:47:48 +0000
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office"
xmlns:w=3D"urn:sc=
hemas-microsoft-com:office:word"
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html;
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@[EMAIL PROTECTED]
Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal
style=3D'mso-margin-top-alt:.2in;margin-right:0in;marg=
in-bottom:
..2in;margin-left:0in;line-height:14.4pt'><font size=3D2 color=3Dblack
face=
=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:black'>I have a linked
se=
rver
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
wri=
te
or update to that table. Anyone have any ideas.</span></font><font
size=3D1 color=3Dblack><span
style=3D'font-size:8.5pt;color:black'><o:p></o=
:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span
style=3D'font-size:1=
0.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
--NextPart_Webmail_9m3u9jl4l_20385_1210111635_0
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
--
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--NextPart_Webmail_9m3u9jl4l_20385_1210111635_0--
