Re: contrib/snapshot

On Jan 2, 2011, at 6:50 PM, Joel Jacobson wrote:
> 2011/1/3 Joel Jacobson <joel(at)gluefinance(dot)com>
> 2011/1/2 Jim Nasby <jim(at)nasby(dot)net>
> Is it actually limited to functions? ISTM this concept would be valuable for anything that's not in pg_class (in other words, anything that doesn't have user data in it).
>
> Instead of limiting the support to functions, perhaps it would make more sense to limit it to all non-data objects?
> Is there a term for the group of object types not carrying any user data?
>
>
> My bad, I see you already answered both my questions.
> So, it does make sense, and the term for non-data object types is therefore non-pg_class, non-class or perhaps non-relation objects?

The generic term for objects that keep their metadata in pg_class is "relation".

Actually, now that I think about it, existence in pg_class isn't a good determining factor, because there's stuff like types in there.

Aside from tables and sequences, you might also want to exclude indexes, or at least provide the option to, since rebuilding them could take a significant amount of time.
--
Jim C. Nasby, Database Architect jim(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net