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

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: 2005-12-06 19:07:13
Message-ID: 15186.1133896033@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-odbc
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

In response to

Responses

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2005-12-06 19:27:49
Subject: Re: [ODBC] BLOB handling compatibility with PostgreSQL > 7.4
Previous:From: Ludek FinstrleDate: 2005-12-06 18:44:02
Subject: Re: [ODBC] BLOB handling compatibility with PostgreSQL > 7.4

pgsql-interfaces by date

Next:From: Ludek FinstrleDate: 2005-12-06 19:27:49
Subject: Re: [ODBC] BLOB handling compatibility with PostgreSQL > 7.4
Previous:From: Ludek FinstrleDate: 2005-12-06 18:44:02
Subject: Re: [ODBC] BLOB handling compatibility with PostgreSQL > 7.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group