Postgres Pro
Downloads
Home   >   mailing lists

problem with TRUNCATE TABLE in plpgsql function - Mailing list pgsql-bugs

From Pavel Stehule
Subject problem with TRUNCATE TABLE in plpgsql function
Date
Msg-id Pine.LNX.4.44.0211011305300.13927-100000@kix.fsv.cvut.cz
Whole thread Raw
In response to 7.2.1: Can't create prcedural language PLPERL  (Ruslan A Dautkhanov <rusland@scn.ru>)
Responses Re: problem with TRUNCATE TABLE in plpgsql function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
Hi all

I played with some own old plpgsql functions. I found "error" in plpgsql
7.3. When I use TRUNCATE TABLE in function I get

TRUNCATE TABLE cannot be executed from a function.

In 7.2.2. I can use this command. Why, now I can't use truncate table?

Thank you
Pavel Stehule

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #809: View not using index
Next
From: Tom Lane
Date:
Subject: Re: problem with TRUNCATE TABLE in plpgsql function