Re: TRUNCATE - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: TRUNCATE
Date
Msg-id GNELIHDDFBOCMGBFGEFOIEJFCCAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: TRUNCATE  (nconway@klamath.dyndns.org (Neil Conway))
List pgsql-hackers
> > It seems to me that there's more and more need for an 'SET CONSTRAINTS
> > DISABLED' and 'SET CONSTRAINTS ENABLED' command that affects
> only foreign
> > keys.
>
> I really dislike the idea of referring to "constraints" but only affecting
> foreign key constraints.

All the other SET CONSTRAINTS statments refer only to foreign keys...

> And what would be the security/data-integrity ramifications of allowing
> this?

Well, if only super users could do it...

Chris



pgsql-hackers by date:

Previous
From: nconway@klamath.dyndns.org (Neil Conway)
Date:
Subject: Re: TRUNCATE
Next
From: Mike Mascari
Date:
Subject: Re: Operator Comments