AW: Proposal: TRUNCATE TABLE table RESTRICT - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: Proposal: TRUNCATE TABLE table RESTRICT
Date
Msg-id 219F68D65015D011A8E000006F8590C604AF7DD1@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers

> > How about this: Prevent truncate on table referenced by foreign key
> > 
> 
> Actually, I made it:
> 
>     * Prevent truncate on table with a referential integrity trigger
> 
> Is that good?

No, I think that is only one point. I think you also need to
check if tables that are referencing this table are empty.

Andreas


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sigh, LIKE indexing is *still* broken in foreign locales
Next
From: Bruce Momjian
Date:
Subject: Re: freefuncs.c is never called from anywhere!?