On Tue, 2007-01-23 at 14:49, Brandon Aiken wrote: > Nevertheless, the database should be able to handle any combination of > syntactically correct SQL statements without throwing errors and > maintaining the database in a consistent state. If what you're saying > is right, the error thrown here is not a user configuration error, but > an RDBMS implementation error. > > A development database is still obviously an important role for > PostgreSQL to function in (as far as PostgreSQL's dev team is concerned, > a development database *is* a "production" use since once of *their* > end-users experiences the problem) and it needs to be able to handle > cases such as this with no problems. And no matter how unlikely it is > to be in a production environment, *someone* will try to modify their > schema dynamically like this. > > I'm wondering if there is a race condition in CREATE or DROP with > respect to triggers and foreign keys. If that's the case, it's going to > affect someone eventually. When I said it doesn't bother me, I meant it literally me, not implying the Postgres community in any way :-) And I did report it that time (I can't find the mail, but I think Tom had a look at it and probably decided it is not top priority). Cheers, Csaba.