Re: Feature request: Truncate table

Bradley Kieser wrote:
> Well in Ingres there is a WORLD of difference! For a start, you don't 
> lock out the system catalog. Secondly it is an unlogged event, so it 
> beats "delete from table_name" hands down! Then, of course, it preserves 
> all permissions, you keep the same OID, so views, et al, can remain in 
> tact, as with other objects that referece it.
> 
> These are very important considerations in real-world applications esp. 
> when a large number of objects may reference the table.
> 
> 
> Which brings me to another point - I would dearly love to see a 
> "refresh" option based on object name added to the system. This would 
> check all references to a dropped object, by name, and repoint them to 
> the new instance of that object (i.e. if you do a drop/create, it 
> doesn't mess up your entire system if you forgot about a view or three!).

We have actually be moving away from name-based linking so you can
rename tables and things still work.  I can see value in a relinking
system, but we would have to know the old oid and new name, I guess.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026