Scott Marlowe <scott.marlowe@xxxxxxxxx> writes: > On Wed, May 4, 2011 at 11:04 AM, Mark Stosberg <mark@xxxxxxxxxxxxxxx> wrote: >> Further, since TRUNCATE permanently and instantly deletes mass amounts >> of data, I would hope that it would provide "safety" by default, but >> only truncating one table unless I specify otherwise. The reason it works like that is that the SQL standard says so :-( There was considerable angst about this when we made TRUNCATE recurse to children, IIRC, but we decided we had to make it work that way. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
