On Thu, Nov 20, 2008 at 6:21 AM, Sabin Coanda <sabin.coanda@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general