truncate problem

From: frank_lupo <frank_lupo(at)email(dot)it>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: truncate problem
Date: 2003-02-20 10:20:27
Message-ID: HALRE3$EF9C9EBD569972723A32740DC9E62A33@email.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I change to 7.3.2 database postgresql from 7.2.2 version.
I am using cygwin:
PostgreSQL 7.3.2 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927 (prerelease)

In 7.2.2 I created a function using the instruction TRUNCATE TABLE inside and it works well.

When I try to call the same function in 7.3.2, I receive the following message:
ERROR: TRUNCATE TABLE cannot be executed from a function.

Thank you for the help

Bye !!
Frank Lupo (Wolf) !!

/\_ _/\
\ o o /
--ooo-----ooo---

--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Oro, argento, diamanti e pietre preziose: una miniera di meraviglie.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=772&d=20-2

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-02-20 10:23:54 Re: Restoring to a certain schema
Previous Message Richard Huxton 2003-02-20 10:19:28 Re: Removing spaces