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
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 |