Bug in create table? - Mailing list pgsql-hackers

From Maurice Gittens
Subject Bug in create table?
Date
Msg-id 006201bd4f8c$7686bf80$fcf3b2c2@caleb..gits.nl
Whole thread Raw
List pgsql-hackers
Hi,

While finding out more about powers of postgresql I encountered the
following:

<PSQL SESSION>
create table t(f1 int,  f2 t);
</PSQL SESSION>

This gives an error message:

"type name lookup of t failed".

However according to the comments for the function "BuildDescForRelation",
this should succeed. It seems like some functions in parse_type.c are
don't consider this case as a valid one.

The following case doesn't give any errors.

<PSQL SESSION>
create table t1(f1 int);
create table t2(f1 int, f2 t);
</PSQL SESSION>

Does anyone have experience using these complex types in tables?

Thanks for any hints,
Maurice


pgsql-hackers by date:

Previous
From: Patrice HEDE
Date:
Subject: Re: [HACKERS] Minor detail...
Next
From: "Maurice Gittens"
Date:
Subject: OO and relation models (was: newoid in invapi,c)