Date: Fri, 22 Apr 2005 21:18:00 +0200
From: Jakub =?ISO-8859-2?Q?Wo=BCny?= <kubaw@o2.pl>
To: pgsql-sql@postgresql.org
Subject: C function - other process
Message-ID: <20050422211800.241cf201@localhost>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

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

-- 
kubaw@o2.pl