Generate next Serial number for table

[eluser]Unknown[/eluser]
Hi,
I am working on a supply chain application. Instead of auto increment, I am looking to handle the database table's ID number from another table.

Here is the solution, I am looking to use it for my CI and postgresql. http://www.sqlsnippets.com/en/topic-11881.html

Is there any plugin or solution that was implemented for codeigniter and postgresql. I greatly appreciate any pointers for my question.

thanks
Kalyan