Does PostgreSQL sequences deal with these kinds performance questions? Is it clean, fast and secury to use sequences? Maybe I still can make up my boss mind about this subject if I get good arguments here to justify the use of sequences.
Sorry, but you just outlined a sequence replacement which is a big hunk of PL/PgSQL! How is that not completely specific to PostgreSQL? The PgSQL 'serial' type is close enough to other RDBMS autoincrement types that porting to a different DB should be trivial. Porting your PL/PgSQL, that will be hard (particularly if you decide to go to something like MySQL, which doesn't even support procedural languages).
--
__
/
| Paul Ramsey
| Refractions Research
| Email: [EMAIL PROTECTED]
| Phone: (250) 885-0632
\_
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
