Re: [HACKERS] DROP INHERITS

2006-06-06 Thread Greg Stark
Tom Lane <[EMAIL PROTECTED]> writes: > > I suppose it makes more sense to optimize this on the basis of what's used > > in > > the planner and executor rather than ALTER TABLE commands though. > > No, definitely not. Syscaches only exist to support hard-wired lookups > in the backend C code.

Re: [HACKERS] DROP INHERITS

2006-06-06 Thread Tom Lane
Greg Stark <[EMAIL PROTECTED]> writes: > I have a question about pg_depends, namely how do you identify the dependency > tied to a given relationship. Specifically to handle DROP INHERITS. Is there > any other reason there might be a dependency between two tables other than > inheritance? If there

[HACKERS] DROP INHERITS

2006-06-06 Thread Greg Stark
I have a question about pg_depends, namely how do you identify the dependency tied to a given relationship. Specifically to handle DROP INHERITS. Is there any other reason there might be a dependency between two tables other than inheritance? If there was how would you tell the dependencies apart