Re: can't create type lo (BLOB)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Daniel Schuchardt" <daniel_schuchardt(at)web(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: can't create type lo (BLOB)
Date: 2003-01-03 20:14:28
Message-ID: 11020.1041624868@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Daniel Schuchardt" <daniel_schuchardt(at)web(dot)de> writes:
> Why this? With PostrgreSql 7.2 this works well.

7.3 tries to enforce type safety (with 7.2 it's trivial to create type
definitions that crash the server when used). Your type declaration
doesn't pass because the I/O functions are declared to be for int4,
not lo.

My advice as of 7.3 would be to create type lo as a domain alias for
type OID:

regression=# create domain lo as oid;
CREATE DOMAIN

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-01-03 21:03:47 Re: postmaster.pid
Previous Message Jean-Luc Lachance 2003-01-03 20:11:26 cache lookup failed on COPY