| From: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
|---|---|
| To: | "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "'Don Baccus'" <dhogaza(at)pacifier(dot)com> |
| Cc: | "'Mike Mascari'" <mascarm(at)mascari(dot)com>, "'Tatsuo Ishii'" <t-ishii(at)sra(dot)co(dot)jp>, "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | AW: Proposal: TRUNCATE TABLE table RESTRICT |
| Date: | 2000-06-09 08:09:11 |
| Message-ID: | 219F68D65015D011A8E000006F8590C604AF7DD1@sdexcsrv1.f000.d0188.sd.spardat.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2000-06-09 10:32:06 | Re: freefuncs.c is never called from anywhere!? |
| Previous Message | Tom Lane | 2000-06-09 07:23:08 | Re: Sigh, LIKE indexing is *still* broken in foreign locales |