Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 8E508632E0D
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 19 Jul 2010 08:05:04 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 84669-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 19 Jul 2010 11:04:57 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail.gmx.net (mailout-de.gmx.net [213.165.64.22])
	by mail.postgresql.org (Postfix) with SMTP id 1F7ED632723
	for <pgsql-sql@postgresql.org>; Mon, 19 Jul 2010 08:04:56 -0300 (ADT)
Received: (qmail invoked by alias); 19 Jul 2010 11:04:54 -0000
Received: from fsgw.f-secure.com (EHLO [10.128.133.70]) [193.110.108.33]
	by mail.gmx.net (mp002) with SMTP; 19 Jul 2010 13:04:54 +0200
X-Authenticated: #495269
X-Provags-ID: V01U2FsdGVkX190uldprTF0vjcn0+lMMwcFAfe71i/BS1M9/fGFo1
	94O83k/egJGbl0
Subject: Re: How oids of the base data types often change?
From: Peter Eisentraut <peter_e@gmx.net>
To: Dmitriy Igrishin <dmitigr@gmail.com>
Cc: postgres list <pgsql-sql@postgresql.org>
In-Reply-To: <AANLkTimI5g1xOdMBWZNa5RV3BnR66dfuy9UmoHLPHRiT@mail.gmail.com>
References: <AANLkTimI5g1xOdMBWZNa5RV3BnR66dfuy9UmoHLPHRiT@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Date: Mon, 19 Jul 2010 14:04:53 +0300
Message-ID: <1279537493.4903.3.camel@fsopti579.F-Secure.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.30.2 
Content-Transfer-Encoding: 8bit
X-Y-GMX-Trusted: 0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201007/77
X-Sequence-Number: 34390

On mån, 2010-07-19 at 14:47 +0400, Dmitriy Igrishin wrote:
> For example, when using libpq(-xx), it is possible to get the oid of
> the type of any column.
> Is there a guarantee that oids of base types (void, integer, ... )
> will not change in future
> releases of Postgres?

There is no actual "guarantee" written in stone, but the OIDs of those
types haven't changed in 10+ years, and there is no conceivable reason
to change them, so you can be pretty sure that they'll remain the same.