Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: [ODBC] BLOB handling compatibility with PostgreSQL > 7.4


  • From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • To: Ludek Finstrle <luf(at)pzkagis(dot)cz>
  • Cc: pgsql-interfaces(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org
  • Subject: Re: [ODBC] BLOB handling compatibility with PostgreSQL > 7.4
  • Date: Tue, 06 Dec 2005 14:07:13 -0500
  • Message-id: <15186.1133896033@sss.pgh.pa.us> <text/plain>

Ludek Finstrle <luf(at)pzkagis(dot)cz> writes:
> I don't want to reinvent the wheel.

Why do you feel a need to distinguish the domain from its underlying
type on the client side?  They're the same as regards representation
and so on.

The reason for the backend change was that client-side drivers (such as
JDBC and ODBC) want to know the underlying datatype so that they know
what representation to use etc.  Distinguishing domains made their job
harder not easier.

If you want an add-on datatype that is really different from OID, then
make a real datatype (CREATE TYPE).  You can still piggyback on OID as
the representation type --- steal its I/O functions and so on.

			regards, tom lane



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group