Kees Jongenburger wrote:
Hello
Can anybody tell me how to export data from a postgress 7.2 database the tables where created using mmbase 1.6.4
I have all sort of funky problems
-I must export using the tar of custrom format
-import does not work because of the node_check function
KL so you want to disable check constraints?
flax so i could mimic OO with postgresql
flax indeed :D
KL flax: one sec
* RubyPanther ([EMAIL PROTECTED]) has left #postgresql ("stage.exit(:left)")
flax and also foreignkeys, but that is an other story i guess
KL flax: no, they're all just triggers. hang on.
KL flax: ok, you do this:
flax btw: im using 7.2 but if it is a 8.0 feature only i also would like to know :D
KL flax: holy crap 7.2
KL anyway, this should still work i think
KL flax: you know it's buggy and slow, right :)
KL begin;
KL -- Disable triggers
KL UPDATE pg_catalog.pg_class SET reltriggers = 0 WHERE oid = 'jobs_lw'::pg_catalog.regclass;
KL COPY...
KL -- Enable triggers
KL UPDATE pg_catalog.pg_class SET reltriggers = (SELECT pg_catalog.count(*) FROM pg_catalog.pg_trigger where pg_class.oid = tgrelid) WHERE oid = 'jobs_lw'::pg_catalog.regclass;
KL commit;
KL but replace 'jobs_lw' with your table name
flax great! Thank you!
flax and this will also work for foreign keys?
KL yes, it disables all triggers
KL flax: i got that code by going: pg_dump --disable-triggers -t jobs_lw -a renderer
_______________________________________________ Developers mailing list [email protected] http://lists.mmbase.org/mailman/listinfo/developers
