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