On 09.08.2011 08:27, Tom Lane wrote:
> select ... from pg_cast c where c.oid>= 16384;
>
> What that really does is eliminate the casts that were installed during
> initdb, which are at least a subset of the "system" ones, and might be
> all of them depending on what you feel a "system" cast is. The main
> shortcoming of it is that there's no very good way to eliminate casts
> installed by extensions, should you want to not consider those "user"
> casts.
That will also exclude "system" casts that have been removed, and
manually re-created later.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com