Feature request - CREATE TYPE ... WITH OID = oid_number.

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Feature request - CREATE TYPE ... WITH OID = oid_number.
Date: 2010-12-07 14:10:50
Message-ID: AANLkTinYmj8rXk_zhw-OhiMBeZWy3k2RHusOk0QfdGbh@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hey hackers@,

libpq execution function works with OIDs. In some cases it is
highly recommended specify OIDs of parameters according to
libpq documentation.
While developing a database application with libpq and if
application works with custom data types IMO reasonable to
provide developer extended type creation syntax, e.g.
CREATE TYPE my_type ... WITH OID = 12345;
Yes, it is possible to make dump of the database with oids,
but if developer prefer to hard code OIDs in the application it
would be more convenient for him to use syntax above.
Btw, there is already Oid lo_import_with_oid function in large
objects libpq's API which are very useful.

What do you think about it?

--
// Dmitriy.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tim Bunce 2010-12-07 14:24:17 Optimize PL/Perl function argument passing [PATCH]
Previous Message Florian Pflug 2010-12-07 13:50:38 Re: serializable read only deferrable