Re: cache lookup error for shell type creation with incompatible output function (DDL deparsing bug) - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: cache lookup error for shell type creation with incompatible output function (DDL deparsing bug)
Date
Msg-id 20150422193622.GG4369@alvh.no-ip.org
Whole thread Raw
In response to Re: cache lookup error for shell type creation with incompatible output function (DDL deparsing bug)  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Alvaro Herrera wrote:
> Michael Paquier wrote:
> > Hi all,
> > 
> > I just bumped into the following problem in HEAD (1c41e2a):
> > =# create type my_array_float (INPUT = array_in, OUTPUT = array_out,
> > ELEMENT = float4, INTERNALLENGTH = 32);
> > ERROR:  XX000: cache lookup failed for type 0
> > LOCATION:  format_type_internal, format_type.c:135

I also wanted to point out, but forgot, that this command is not really
creating a shell type -- it's creating a full-blown type, because there
are args.  Shell types are created when no args are given.  This happens
to fail due to the internal creation of the shell type because of the
failure to look up the i/o functions, but as far as I can see the
original code should fail in any type creation in pretty much the same
way (didn't actually test that); not completely sure why this wasn't
more visible in regression tests.

I simply removed the word "shell" in the provided test case in the
committed version, anyway.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Streaming replication and WAL archive interactions
Next
From: Petr Jelinek
Date:
Subject: Re: Sequence Access Method WIP