Hello,

The following is a patch which patches cleanly 
against the 6.5 release and which implement's
Oracle's TRUNCATE statement.

There are a few things to note about this patch:

1. It mirrors the operation of VACUUM in that it 
   acquires an Access Exclusive lock on the relation
   being TRUNCATE'd (as well as its indexes, as 
   necessary).

2. It currently does not update pg_class with either
   the "bogus" stats of 1000 tuples nor does it set 
   the number of tuples to 0.

3. You must have pg_ownercheck() permissions to 
   TRUNCATE a table.

I hope the PostgreSQL professionals can clean
this up sufficient enough to be useful to the rest
of the world (I find it increasingly useful as we
add more and more users).

Marcus "Mike" Mascari (mascarim@yahoo.com)




_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Wed, 30 Jun 1999 13:23:03 -0700 (PDT)
Marcus Mascari <mascarim@yahoo.com>
TRUNCATE statement patch