problem with TRUNCATE TABLE in plpgsql function

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: problem with TRUNCATE TABLE in plpgsql function
Date: 2002-11-01 12:09:31
Message-ID: Pine.LNX.4.44.0211011305300.13927-100000@kix.fsv.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message saurabh garg 2002-11-01 14:33:25 hi-problem in postgresql postmaster service
Previous Message saurabh garg 2002-11-01 05:37:11 Fwd: hi-problem in creating database & user in postgresql