The following bug has been logged online:
Bug reference: 1770
Logged by: David Fetter
Email address: david(at)fetter(dot)org
PostgreSQL version: 8.0.3
Operating system: Linux
Description: Composite type dependency broken
Details:
Here's a repro (psql):
create table foo (foo_id SERIAL PRIMARY KEY, foo_text TEXT NOT NULL);
CREATE type two_foos AS (foo1 foo, foo2 foo);
CREATE type four_foos AS (two_foo1 two_foos, two_foo2 two_foos);
DROP TABLE foo CASCADE;
Perhaps I have misunderstood, but I would think that both two_foos and
four_foos would disappear as a result of this. They don't :/
Cheers,
D