On Thu, Nov 20, 2008 at 6:21 AM, Sabin Coanda
<sabin.coanda@deuromedia.ro> wrote:
> Hi,
>
> I have "PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
> 3.4.2 (mingw-special)" on Windows OS , but I experienced the same problem on
> "PostgreSQL 8.3.5, compiled by Visual C++ build 1400" too.
>
> I attach the demo database here, to be available to test according with the
> following scenario.
>
> I found in a STABLE function, for instance "TEST_0"(), it is not allowed to
> use INSERT statement. Trying this will give me the error:
> ERROR: INSERT is not allowed in a non-volatile function
Why did you lie when your declared your function stable? :-)
merlin