Thread: Bug in create table?

Bug in create table?

From
"Maurice Gittens"
Date:
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