Frank van Vugt <ftm.van.vugt@xxxxxxx> writes: > Op woensdag 20 april 2011, schreef Tom Lane: >> Actually, now that I think about it, 8.4 didn't allow on-the-fly >> reindexing of shared catalogs anyway. So that couldn't be your problem >> even if the test had shown the indexes didn't match the catalog. But >> it seems the rows actually disappeared from the catalog, and I have no >> idea what would've caused that. > should we even try to get them back by generating them somehow? It's not really important --- the only difficulty with not having them is the one you already hit, that REASSIGN OWNED misses things it should do. If you're planning an update or dump-and-reload shortly, I wouldn't worry about it. What's much more worrisome is the question of whether the same kind of data loss happened anywhere else, and that isn't something that the available info tells me anything about. > also: would there be any reason you can think of why using alter function in > the current version in order to correct this situation would have a negative > side-effect? If you do want to go around and do retail ALTER OWNER commands, you certainly could. I thought for a moment that changeDependencyOnOwner would complain about the lack of a pre-existing pg_shdepend entry, but I see it won't, so it should work fine. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
