Bug in create table?

From: "Maurice Gittens" <mgittens(at)gits(dot)nl>
To: "PostgreSQL-development" <hackers(at)postgreSQL(dot)org>
Subject: Bug in create table?
Date: 1998-03-14 21:02:13
Message-ID: 006201bd4f8c$7686bf80$fcf3b2c2@caleb..gits.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Maurice Gittens 1998-03-14 21:25:57 OO and relation models (was: newoid in invapi,c)
Previous Message Patrice HEDE 1998-03-14 20:14:22 Re: [HACKERS] Minor detail...