From: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
---|---|
To: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
Subject: | table dump |
Date: | 2002-04-09 14:10:19 |
Message-ID: | 00a001c1dfd0$4818a1d0$de138f80@virginia.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I just completed a data only dump of a table by using the following command:
pg_dump genex -Rau -t species > species.sql
I noticed that the first line of the file seems to be disabling some postgres trigger. It reads:
UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'species';
Then all the data is listed.
At the end of the file the triggers are enabled again with the following command:
UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'species';
Can someone explain why this is happening? The problem is that I am coping this dump into another schema creation file that I have. I want the data from this particular file included in with my new database. However, I am creating this database with a user account so that all tables will be owned by that user. I think the problem here is that this trigger stuff requires that you be signed in as postgres in order to do anything with the pg_class table. correct?
Any assistane would be greatly appreciated.
thanks,
Jodi
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-04-09 15:53:25 | Re: table dump |
Previous Message | Tom Lane | 2002-04-08 21:45:37 | Re: Will an outer join on two indexed fields use the indexes? |