pg_dump ignore CASTs when using --schema

From: Felix Ostmann <felix(dot)ostmann(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: pg_dump ignore CASTs when using --schema
Date: 2016-03-04 06:56:23
Message-ID: CADxtucYjzcW5UyvfxG7HKy_1yVLnfjyA9fMBikb2xRzvsvT8fg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Shulgin, Oleksandr 2016-03-04 15:12:51 Re: BUG #13997: does not work ILIKE + UTF8
Previous Message Michael Paquier 2016-03-04 02:57:13 Re: BUG #13770: Extending recovery_min_apply_delay on Standby causes it to be unavailable for a while