pg_dump ignore CASTs when using --schema - Mailing list pgsql-bugs

From Felix Ostmann
Subject pg_dump ignore CASTs when using --schema
Date
Msg-id CADxtucYjzcW5UyvfxG7HKy_1yVLnfjyA9fMBikb2xRzvsvT8fg@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump ignore CASTs when using --schema  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hello,

we have a problem with pg_dump and CAST. After some digging and asking
someone pointed me to this email address.

Our server: postgresql-9.4 - 9.4.6-0+deb8u1
Our problem:

http://blog.endpoint.com/2015/02/postgres-pgdump-implicit-cast-problem.html?showComment=1424179126489#c5762559318074857599

short example:

$ pg_dump -s --schema testschema testdatabase | grep CAST
$ pg_dump -s testdatabase | grep CAST
-- Name: CAST (text AS testschema.enum_users_title); Type: CAST; Schema:
pg_catalog; Owner:
CREATE CAST (text AS testschema.enum_users_title) WITH FUNCTION
testschema.cast_users_title(text) AS IMPLICIT;

Have a nice day
Felix Ostmann

pgsql-bugs by date:

Previous
From: Evgeniy Shishkin
Date:
Subject: Re: BUG #14000: initdb installs in 9.4 by default
Next
From: Andres Freund
Date:
Subject: Re: BUG #13844: Logical decoding bug with subxact + row locking