From: | Anand Raman <araman(at)india-today(dot)com> |
---|---|
To: | postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_dump issues.. |
Date: | 2001-01-05 06:54:21 |
Message-ID: | 20010105122421.D23795@india-today.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi guys
While getting a dump of my tables i am finding the following sql
statements..
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" !~ '^pg_'
GROUP BY 1;
UPDATE "pg_class" SET "reltriggers" = TMP."tmp_reltriggers" FROM "tr"
TMP WHERE "pg_class"."relname" = TMP."tmp_relname";
COMMIT TRANSACTION;
Since i am not dumping and recreating as the postgresql superuser the
shel script signals a error..
What are these lines for anyway in the dump file..
I am using the following command to dump
for i in ntoday_users media weather content content_section content_priorities citylight left_panel
do
pg_dump -h $ORIG_DB -a -u -t $i news < passwd 2>>$LOG_FILE 1>> $DUMP_FILE
done
From | Date | Subject | |
---|---|---|---|
Next Message | Justin | 2001-01-05 07:14:24 | Re: How do I create a check constraint that is based on age difference? |
Previous Message | Anthony E . Greene | 2001-01-05 06:11:51 | Re: Test for existence of Table |