Joe Conway <[EMAIL PROTECTED]> writes: > I'm not sure I interpreted the intent of findoidjoins just right, but > here it is updated for schemas, new reg* types, using SPI instead of > libpgeasy, and returning the results as a table function. Any > corrections/comments?
For what we want it for (viz, regenerating the oidjoins test every so often), this is really a step backwards. It requires more work to run than the original program, and it modifies the database under test, which is undesirable because it's commonly run against template1. I was thinking of keeping it as a client program, but recasting it to use libpq since libpgeasy isn't in the standard distribution anymore. I've looked through my notes and I can't find why I thought findoidjoins was broken for 7.3. Did you come across anything obviously wrong with its queries? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster