On 18 Oct 2011, at 20:17, Tom Lane wrote: > =?ISO-8859-1?Q?Fr=E9d=E9ric_Rejol?= <frederic.rejol@xxxxxxxxx> writes: >> I created a custom CAST to cast from one table type to another. >> pg_dump does not include my custom CAST. > > Hmm. The reason for that is that the table types aren't considered > dumpable objects. I suppose we need to fix that, but in the meantime > you'd have better luck if you created the types as composite types > instead of implicit table rowtypes. Maybe worth adding to the TODO. Casts do exist in the database persistently, don't they ? In which case it is only fair to have them in pg_dump, me thinks. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general