Folks,
Pardon the dup, but I couldn't post via the web site :/
The following bug has been logged online:
Bug reference: 1770
Logged by: David Fetter
Email address: david@fetter.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
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
