I just copied a rather complex application database together with all tables and triggers to 8.0.0RC1 running under windows (the original 7.4 database still runs on linux). I migrated everyting using pg_dump and then executing the resulting scripts via pgsql.
Most things work as expected until now, except for the following problem.
My application uses some functions that use the information_schema. Now these functions seem to fail. Further ysis reveals that some of the dictionary views (e.g. information_schema.table_constraints) always give empty result sets.
I can see several differences between 7.4 and 8.0RC1, mainly with schema-qualifiyng all names. Below ...