Re: pg_restore problems and suggested resolution

From: Joseph Tate <jtate(at)dragonstrider(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_restore problems and suggested resolution
Date: 2004-02-13 22:13:07
Message-ID: 402D4BF3.8050102@dragonstrider.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Joseph Tate wrote:

> I propose pg_restore --disable-triggers be modified so that triggers are
> disabled on the tables that OID fixing is going to UPDATE. I'll
> hopefully have a patch against REL7_4_STABLE for this soon, but I
> haven't started it yet. Does anyone have any suggestions? Has someone
> already done this in HEAD so that it can be backported to 7.4?
>

So now that I've looked at the code, I think that this solution is a
little too simplistic unfortunately. Now I'm leaning towards
--diable-rules. Am I correct in thinking that if I change
pg_class.relhasrules to 'f' that the rules will not be processed? Or is
there more involved here?

Joseph

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Edwin S. Ramirez 2004-02-13 22:15:30 Re: Transaction aborts on syntax error.
Previous Message Tom Lane 2004-02-13 21:31:45 Re: Transaction aborts on syntax error.