Re: pg_dump doesn't dump conversions?

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