Re: SPI_execute_with_args call

Gavin Flower <GavinFlower@xxxxxxxxxxxxxxxxx> · Fri, 03 May 2013 22:31:59 +1200



    On 03/05/13 21:19, Yuriy Rusinov wrote:

    
      Hello, colleagues !
        

        I have to write random number generator state into database
          table
        Table structure is 
        table rand_state
        {
            id serial not null primary key,
            state_rand bytea
        };
        

        In C-function I do
        size_t nr_ins = strlen ("insert into rand_state
          (state_rand) values ($1);");

        
        char * r_sql = (char *) palloc (nr_ins + 1);
        strncpy (r_sql, "insert into rand_state (state_rand) values
          ($1);", nr_ins);
        

            Oid * oids = (Oid *)palloc (sizeof (Oid));
            Datum * val = PointerGetDatum (randBuf);
            *oids = BYTEAOID;
            const char * nulls = "NULL";
            int rins = SPI_execute_with_args (r_sql, 1, oids, val,
              nulls, false, 1);
          
          
          randBuf is a void * pointer that contains random
            number generator state,
          when I try to execute SPI_execute_with_args
            (r_sql, 1, oids, val, nulls, false, 1); I receive error 
          The connection to the server was lost.
            Attempting reset: Failed.

          
          Could you give some work examples for
            SPI_execute_with_args because I didn't find them in
            documentation. 
          

          Thanks a lot.
          

          -- 

          Best regards,

          Sincerely yours,

          Yuriy Rusinov.

        
    I can't answer your question.

        
        However, I can say that PRIMARY
            KEY implies NOT NULL (also an UNIQUE index), so you don't
            need to explicitly add NOT NULL when you are specifying
                          PRIMARY KEY!

                                    
                                    Cheers,

                                      Gavin