Re: about truncate - Mailing list pgsql-hackers

From David Fetter
Subject Re: about truncate
Date
Msg-id 20081222034238.GF4200@fetter.org
Whole thread Raw
In response to about truncate  ("Jaime Casanova" <jcasanov@systemguards.com.ec>)
Responses Re: about truncate  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sun, Dec 21, 2008 at 10:09:54PM -0500, Jaime Casanova wrote:
> Hi,
> 
> just out of curiosity, why TRUNCATE doesn't support ONLY?
> 
> audit=# TRUNCATE only postgres_log;
> ERROR:  syntax error at or near "only"
> LINE 1: TRUNCATE only postgres_log;

Given that the main (and only sane, IMHO) use for table inheritance is
in table partitioning, can we see about deprecating ONLY (in the table
inheritance sense) for the next couple of development cycles and then
removing it?

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: Proposed Patch to Improve Performance of Multi-Batch Hash Join for Skewed Data Sets
Next
From: Tom Lane
Date:
Subject: Location for window function API definitions