Zeugswetter Andreas SB wrote:
>
> Truncate should probably check if all referencing tables are empty
> and fail if not. Truncate should imho not lead to a violated constraint
> situation.
> Strictly speaking the current situation is more or less a bug.
>
Not anything is possible with RI, so the DB schema might use regular triggers and/or rules as well.
Why not reject TRUNCATE at all if the relation has rules/triggers? IMHO the only safe way.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #