pg_dump issues
От | Rod Taylor |
---|---|
Тема | pg_dump issues |
Дата | |
Msg-id | 05e401c0863e$a377ddd0$2205010a@jester обсуждение исходный текст |
Ответы |
Re: pg_dump issues
|
Список | pgsql-hackers |
Could we add a flag to remove the postgres specific information from a pg_dump? -- UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" ~* 'market_type'; BEGIN TRANSACTION; CREATE TEMP TABLE "tr" ("tmp_relname" name, "tmp_reltriggers" smallint); INSERT INTO "tr" SELECT C."relname", count(T."oid") FROM "pg_class" C, "pg_trigger" T WHERE C."oid" = T."tgrelid" AND C."relname" ~* 'market_type' GROUP BY 1; UPDATE "pg_class" SET "reltriggers" = TMP."tmp_reltriggers" FROM "tr" TMP WHERE "pg_class"."relname" = TMP."tmp_relname"; DROP TABLE "tr"; COMMIT TRANSACTION; -- These make importing into other database systems rather difficult. -- Rod Taylor There are always four sides to every story: your side, their side, the truth, and what really happened.
В списке pgsql-hackers по дате отправления: