pg_dump issues..

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

Browse pgsql-general by date

  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