Re: [HACKERS] TRUNCATE TABLE patch - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] TRUNCATE TABLE patch
Date
Msg-id 199909280424.AAA00465@candle.pha.pa.us
Whole thread Raw
In response to TRUNCATE TABLE patch  (Mike Mascari <mascarim@yahoo.com>)
List pgsql-hackers
Applied.  Sorry for the delay.  I think Tom Lane fixed the function
calls.


> I submitted a patch to the patches list several
> months ago which implemented Oracle's TRUNCATE TABLE
> statement in PostgreSQL and was wondering whether or
> not the patch was going to make it into current. I had
> the patch ready before the 6.5 release but 6.5 was
> already in beta at the time, so I waited until the
> 6.5 tree was split.
> 
> Recent discussions with regard to the functioning of 
> DROP TAPLE in transactions and changing heap_openr()
> to require a locking type affect the nature of the 
> patch. TRUNCATE TABLE behaves like Oracle's DDL
> statements by committing the running transaction and
> starting a new one for the TRUNCATE operation
> (which generates no rollback information), or, as 
> Bruce Momjian puts it "cheating".
> 
> Any news?
> 
> Just curious,
> 
> Mike Mascari
> (mascarim@yahoo.com)
> 
> 
> 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Bid and sell for free at http://auctions.yahoo.com
> 
> ************
> 
> 


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@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
 


pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: [HACKERS] Vacuum analyze bug CAUGHT
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Doccumentation Patch for Create Function