Re: proper way to fix information_schema.key_column_usage view

April Lorenzen wrote:
> I had to feel my way carrying out this fix, and I don't know if I did
> it right - I only know that it appears I no longer have the error.
> Please confirm whether I was supposed to execute all of
> share/information_schema.sql --- or just the portion that CREATEs or
> REPLACEs key_column_usage view.

If you don't have any dependencies on the information schema (that is,
you have yourself created objects that refer to the information schema,
which should be rare), it is safe to just drop the schema, that is,

DROP SCHEMA information_schema CASCADE;

and reload it

psql -f .../information_schema.sql $PGDATABASE

--
Peter Eisentraut
http://developer.postgresql.org/~petere/