"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > CREATE TABLE inventory ( > invnum character(8) NOT NULL, > description character(255) > );
> CREATE TABLE test ( > inv inventory > ); Table columns can't be composite types. It's possible this will work in 7.5, if anyone does more work on it in the next month, but it hasn't worked since Berkeley days. (And the feature they had didn't work as you expect, either.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend