Just to emphasise how bad this is, the strings 'CONVERSION' and
'pg_conversion' do not appear anywhere in the pg_dump source code.
I'm not putting up my hand to implement it that quickly this close to
release, but it's a thing that should probably be back ported to 7.3, as people will be unable to dump their
conversions.
Chris
Christopher Kings-Lynne wrote:
> Is it just me or does pg_dump have no support for dumping conversions at
> all?
>
> conversions=# CREATE CONVERSION myconv FOR 'UNICODE' TO 'LATIN1' FROM
> alt_to_iso;
> CREATE CONVERSION
> conversions=# \q
>
> bash-2.05a$ /home/chriskl/local/bin/pg_dump conversions
> --
> -- PostgreSQL database dump
> --
>
> SET SESSION AUTHORIZATION 'chriskl';
>
> --
> -- TOC entry 3 (OID 2200)
> -- Name: public; Type: ACL; Schema: -; Owner: chriskl
> --
>
> REVOKE ALL ON SCHEMA public FROM PUBLIC;
> GRANT ALL ON SCHEMA public TO PUBLIC;
>
>
> --
> -- TOC entry 2 (OID 2200)
> -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: chriskl
> --
>
> COMMENT ON SCHEMA public IS 'Standard public schema';
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly