Kevin Barnard wrote: > The basic idea of my proposal would be to have a function that checks > for the existence of C libraries. The next piece I would need would > be a mechanism for psql to halt the restore SQL script if these > checks failed. Finally I would need to add a switch to tell pg_dump > to do the checks first thereby causing the restore to fail, hopefully > with a nice message that clues the admin that something is wrong.
You already get this today. If you create a C function and the library doesn't exist, you get an error, and if you use the right flags for psql or pg_restore, the restoration aborts. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
