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



Wed, 15 Oct 2003 23:32:07 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
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


Thu, 16 Oct 2003 11:19:01 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: pg_dump doesn't dump conversions?
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> 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.

Which people would those be, exactly?  I doubt that very many people
have created their own conversions.  I agree that this should be fixed
in the long run, but I'm having a hard time grading it as a critical
issue ...

			regards, tom lane

Wed, 15 Oct 2003 23:39:22 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump doesn't dump conversions? 
>>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.
> 
> 
> Which people would those be, exactly?  I doubt that very many people
> have created their own conversions.  I agree that this should be fixed
> in the long run, but I'm having a hard time grading it as a critical
> issue ...

Surely it should be really important for us to actually dump what people 
have in their database and also the integrity of their dumps?  I'll 
accept that it's not important enough for a back port in that case?

Chris



Thu, 16 Oct 2003 12:03:50 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: pg_dump doesn't dump conversions?
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> Which people would those be, exactly?  I doubt that very many people
>> have created their own conversions.  I agree that this should be fixed
>> in the long run, but I'm having a hard time grading it as a critical
>> issue ...

> Surely it should be really important for us to actually dump what people 
> have in their database and also the integrity of their dumps?

Let me put it this way: it is vastly more important to fix pg_dump's 
object-ordering problems than to fix its ignorance of conversions.
We are not fixing the former for 7.4, and we wouldn't try to backport
any fix that might appear for 7.5 into 7.4 either.  Conversions won't
get a higher priority.

			regards, tom lane

Thu, 16 Oct 2003 00:06:13 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump doesn't dump conversions? 
Christopher Kings-Lynne wrote:
> > Let me put it this way: it is vastly more important to fix pg_dump's 
> > object-ordering problems than to fix its ignorance of conversions.
> > We are not fixing the former for 7.4, and we wouldn't try to backport
> > any fix that might appear for 7.5 into 7.4 either.  Conversions won't
> > get a higher priority.
> 
> OK, your call.  TODO item Bruce?  May as well assign it to me - i'm 
> working on pg_dump at the moment.

Added to TODO:

	* Allow pg_dump to dump CREATE CONVERSION (Christopher)


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Thu, 16 Oct 2003 00:12:48 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: pg_dump doesn't dump conversions?
> Let me put it this way: it is vastly more important to fix pg_dump's 
> object-ordering problems than to fix its ignorance of conversions.
> We are not fixing the former for 7.4, and we wouldn't try to backport
> any fix that might appear for 7.5 into 7.4 either.  Conversions won't
> get a higher priority.

OK, your call.  TODO item Bruce?  May as well assign it to me - i'm 
working on pg_dump at the moment.

Chris



Thu, 16 Oct 2003 12:16:23 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: pg_dump doesn't dump conversions?