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