pg_dump doesn't dump conversions?
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';
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:
Show quoted text
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=# \qbash-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
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
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
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
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 19073Import Notes
Reply to msg id not found: 3F8E1B97.9000503@familyhealth.com.au | Resolved by subject fallback
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