[phplib] DB_Sql::nextid() questions From: Jason Lee (jlee <email protected>)
Date: 03/14/01

I'm trying to using phplib for this project I'm working on, but I'm
having severe problems with the nextid() method. Apparently, it needs a
table called db_sequence from which it gets the value for a given
sequence, which it manages. I'm using postgres right now, and it seems
to me that the smart thing to do would be SELECT nextval('$seq_name').
Am I missing something?

The need for this table is causing me quite a headache. Currently, the
error I'm getting is

Warning: PostgreSQL query failed: ERROR: LOCK TABLE: permission denied
in db_pgsql.inc on line 99

This could be easily avoided in my situation using nextval. Unless I'm
dumb and missed something important. (I'm not subscribed to the list,
so... ;) Thanks!

-- 
Jason Lee          | Failure is not an option. It comes bundled with every
Programmer/Analyst | Microsoft product. - gaudior (/. reader)

--------------------------------------------------------------------- To unsubscribe, e-mail: phplib-unsubscribe <email protected> For additional commands, e-mail: phplib-help <email protected>