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: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
