From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Peter Childs <Blue(dot)Dragon(at)blueyonder(dot)co(dot)uk>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] 7.4Beta |
Date: | 2003-08-15 07:33:59 |
Message-ID: | 20030815003216.B9630-100000@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On Fri, 15 Aug 2003, Christopher Kings-Lynne wrote:
> > > 1. Add the FK to the table BEFORE COPYing data
> > > 2. Use the old update blah set reltriggers = 0 trick
> > > 3. restore the data
> > > 4. Undo step 2
> >
> > The problem with that is that I think the reltriggers=0 trick only works
> > if you're superuser, I thought that's why the trigger disabling became
> > optional. A set that affected only atac would probably be reasonable in
> > the dump (and presumably easy to do). It'd also carry over to future
> > cases where we separate some check constraints (for examples ones
> > that refer directly or indirectly to the same table in a subselect).
>
> Well yes, this would be a super-user only ability. Are you worried about
> people restoring dumps as non-superuser?
Basically, yes (you might dump only some tables that you own for example).
I think that's why the data only dumps no longer do the reltriggers thing
by default and you need an option to get at it. We could make a similar
option for this case, but it'd only work when restored by a superuser.
From | Date | Subject | |
---|---|---|---|
Next Message | expect | 2003-08-15 07:53:03 | Re: importing db as text files |
Previous Message | Stephan Szabo | 2003-08-15 07:32:01 | Re: importing db as text files |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2003-08-15 09:17:26 | Re: [GENERAL] 7.4Beta |
Previous Message | Christopher Kings-Lynne | 2003-08-15 07:17:21 | Re: [GENERAL] 7.4Beta |