Re: AW: [HACKERS] Proposal: TRUNCATE TABLE table RESTRICT

2000-10-12 Thread Bruce Momjian
[ Charset ISO-8859-1 unsupported, converting... ] > > > TODO updated: > > > > * Prevent truncate on table with a referential integrity > > trigger (RESTRICT) > > I think this was solved in current with a better approach > (checks if referenced table is empty). Removed from TODO. -- Bruce

AW: [HACKERS] Proposal: TRUNCATE TABLE table RESTRICT

2000-10-12 Thread Zeugswetter Andreas SB
> TODO updated: > > * Prevent truncate on table with a referential integrity > trigger (RESTRICT) I think this was solved in current with a better approach (checks if referenced table is empty). Andreas

Re: [HACKERS] Proposal: TRUNCATE TABLE table RESTRICT

2000-10-09 Thread Bruce Momjian
> At 09:24 PM 6/8/00 +0900, Tatsuo Ishii wrote: > >It seems the truncate command deletes all rows from a table even it is > >referenced by another tables. TRUNCATE is not in the standard any way, > >so I would not claim this is a bug. However, sometimes it would be > >helpful for a user to let him

Re: [HACKERS] Proposal: TRUNCATE TABLE table RESTRICT

2000-10-02 Thread Bruce Momjian
Can someone comment on this? > It seems the truncate command deletes all rows from a table even it is > referenced by another tables. TRUNCATE is not in the standard any way, > so I would not claim this is a bug. However, sometimes it would be > helpful for a user to let him notice that the table