Re: disabling OIDs?

From MDEXTER@dexterchaney.com Sat Jun 6 10:03:53 2026 X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AE2D03A62A7 for ; Mon, 13 Dec 2004 17:18:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96526-07 for ; Mon, 13 Dec 2004 17:18:46 +0000 (GMT) Received: from DCIMAIL.dexterchaney.local (guarddog.dexterchaney.com [206.253.218.155]) by svr1.postgresql.org (Postfix) with SMTP id 39EC83A6066 for ; Mon, 13 Dec 2004 17:18:45 +0000 (GMT) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C4E137.EC6F2F2A" Subject: Re: disabling OIDs? Date: Mon, 13 Dec 2004 09:19:37 -0800 Message-ID: <5E8F9F5B63726C48836757FE673B584E0126507B@dcimail.dexterchaney.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Re: disabling OIDs? Thread-Index: AcThN+vnhyDc5VC+Q36axPl/VNmATg== From: "Mark Dexter" To: , X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.078 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, HTML_60_70, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200412/16 X-Sequence-Number: 2712 This is a multi-part message in MIME format. ------_=_NextPart_001_01C4E137.EC6F2F2A Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable For what it's worth, OIDs are required if you ever want to use updateable cursors with the ODBC driver. We discovered this the hard way. Mark Dexter ------_=_NextPart_001_01C4E137.EC6F2F2A Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Re: disabling OIDs?

For what it's worth, OIDs are required = if you ever want to use updateable cursors with the ODBC driver. = We discovered this the hard way. Mark = Dexter

------_=_NextPart_001_01C4E137.EC6F2F2A-- From josh@agliodbs.com Sat Jun 6 10:03:53 2026 X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1107B3AB7FB for ; Wed, 15 Dec 2004 05:27:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21699-10 for ; Wed, 15 Dec 2004 05:27:22 +0000 (GMT) Received: from davinci.ethosmedia.com (server226.ethosmedia.com [209.128.84.226]) by svr1.postgresql.org (Postfix) with ESMTP id 08D173AB81D for ; Wed, 15 Dec 2004 05:27:22 +0000 (GMT) Received: from [63.195.55.98] (account josh@agliodbs.com HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 6787966; Tue, 14 Dec 2004 21:28:56 -0800 From: Josh Berkus Organization: Aglio Database Solutions To: "Mark Dexter" Subject: Re: disabling OIDs? Date: Tue, 14 Dec 2004 21:26:43 -0800 User-Agent: KMail/1.6.2 Cc: , References: <5E8F9F5B63726C48836757FE673B584E0126507B@dcimail.dexterchaney.local> In-Reply-To: <5E8F9F5B63726C48836757FE673B584E0126507B@dcimail.dexterchaney.local> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Message-Id: <200412142126.43375.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.012 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/17 X-Sequence-Number: 2713 Mark, > For what it's worth, OIDs are required if you ever want to use > updateable cursors with the ODBC driver. =C2=A0We discovered this the hard > way. =C2=A0Mark Dexter Well, that would be something to fix in the ODBC driver ... file a bug, eh? =2D-=20 Josh Berkus Aglio Database Solutions San Francisco From MDEXTER@dexterchaney.com Sat Jun 6 10:03:54 2026 X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 45B323B69FE for ; Thu, 16 Dec 2004 17:34:38 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80115-08 for ; Thu, 16 Dec 2004 17:34:33 +0000 (GMT) Received: from DCIMAIL.dexterchaney.local (guarddog.dexterchaney.com [206.253.218.155]) by svr1.postgresql.org (Postfix) with SMTP id 5FEA23B69B7 for ; Thu, 16 Dec 2004 17:34:31 +0000 (GMT) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: Re: disabling OIDs? Date: Thu, 16 Dec 2004 09:35:28 -0800 Message-ID: <5E8F9F5B63726C48836757FE673B584E012B8BC5@dcimail.dexterchaney.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [DOCS] disabling OIDs? Thread-Index: AcTiZur+YoGnyu11TpydWKFCNBWowwBLilsg From: "Mark Dexter" To: "Josh Berkus" Cc: , X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.059 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200412/22 X-Sequence-Number: 2718 I believe the ODBC driver works this way by design. So it's just = something you need to know if you plan to use it with updateable = cursors. It is my impression that the Postgres ODBC driver is somewhat of a "poor = stepchild" within the Postgres community. However, it appears to work. Mark Dexter >Mark, > For what it's worth, OIDs are required if you ever want to use=20 > updateable cursors with the ODBC driver. =A0We discovered this the = hard=20 > way. =A0Mark Dexter Well, that would be something to fix in the ODBC driver ... file a bug, = eh? --=20 Josh Berkus Aglio Database Solutions San Francisco