Bug in Postgresql 7.4 last insert id

[eluser]zeratool[/eluser]
Hello,

when i try to use the $this->db->insert_id after i've done an insert like below :


$this->db->insert('table', $data_arr);
return $this->db->insert_id();

Postgresql 7.4 doesnt return the right sequence id.

pls help thanks.

[eluser]Celso Soares[/eluser]
I have the same problem. In my localhost server $this->db->insert_id(); return the right id.
But when i try the same code in same schema DB in my server it returns values like 399, 400, 401 ...
and the current sequence id is just 10