Re: currval()

Julius Tuskenis <julius@xxxxxxxx> · Wed, 21 Sep 2011 11:41:11 +0300



    Hello, Mark

    
    On 2011.09.21 01:00, Marc Fromm wrote:
    
      
        The field name is ‘id’ and it is a primary
          key. 

        
    ...

    
                        $sql .= "SELECT
          currval('id');";
        

        Marc
      
    
    You should pass sequence name to currval (not field name like you do
    now). If you use pgAdmin sequence name is easily found looking at
    fields definition near the DEFAULT.

    
    example:

    
    ALTER TABLE b_preke ADD COLUMN prek_id integer;

    ALTER TABLE b_preke ALTER COLUMN prek_id SET NOT NULL;

    ALTER TABLE b_preke ALTER COLUMN prek_id SET DEFAULT
    nextval('b_preke_prek_id_seq'::regclass);

    
    the field is prek_id and the sequence is b_preke_prek_id_seq
    -- 
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050