[SQL] C function - other process

[Jakub Woźny]

Hello,

I wrote a simple function:

PG_FUNCTION_INFO_V1(my_fcn);

Datum
my_fcn()
{
    int i,ret;
    i=0;
    signal(SIGCHLD,SIG_IGN);
    switch(fork())
    {
        case 0:
        {
            SPI_connect();       
            for(i=0;i<10;i++)
            {
                SPI_exec("insert into my_tmp values ('asdasd');",1);   
                sleep(1);
            }
            ret = SPI_finish();
            exit(ret);
        }
        default:
        {
            ;
        }
    }
}

Next I create a function in my database:

CREATE FUNCTION my_fcn() RETURNS void
    AS '$libdir/my_fcn', 'my_fcn'
    LANGUAGE c;

Now I execute "select my_fcn();" and I don't see records in table
'my_tmp', but function works.
I checked returns values from SPI function, tehere are correct.
What is wrong?

Best regards,
jakub

-- 
[EMAIL PROTECTED]

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly