Yes,

TRUNCATE foo;
TRUNCATE foo;

works well.

So why do we need 
 
 TRUNCATE foo, foo;

---------------------------------------------------------------------------

On Wed, 2008-07-16 at 16:24 -0400, Bruce Momjian wrote:
> Logically, you should be able to truncate a table twice.
> 
> ---------------------------------------------------------------------------
> 
> Simon Riggs wrote:
> > 
> > On Wed, 2008-07-16 at 16:54 +0000, Bruce Momjian wrote:
> > > Log Message:
> > > -----------
> > > Allow TRUNCATE foo, foo to succeed, per report from Nikhils.
> > 
> > What's the use case for this?
> > 
> > It's not compatibility, is it? Why would you ever do that? If you did,
> > why would you expect it to work? Seems more likely to be a user error
> > than a real request.
> > 
> > Should it throw one trigger call, or two?
> > 
> > BTW, create index foo_idx on foo (col1, col1) fails also with a strange
> > error message. Should we silently merge columns and ignore that also?
> > 
> > ERROR:  duplicate key value violates unique constraint
> > "pg_attribute_relid_attnam_index"
> > 
> > Seems easier to throw errors for weird DDL like this.
> > 
> > e.g. create index concurrently on foo (col1); creates an index called
> > "concurrently" on foo, while holding locks...
> > 
> > -- 
> >  Simon Riggs           www.2ndQuadrant.com
> >  PostgreSQL Training, Services and Support
> 
-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

Reply via email to