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/