Re: LiveUser for postgresql (DB_Table notice)

On Jul 2, 2004, at 3:12 PM, Jean-Philippe Barrette-LaPierre wrote:

On July 2, 2004 04:10 pm, Jean-Philippe Barrette-LaPierre wrote:

there's the Auth_DB.sql and perm_db.sql for postgresql that I made. This should work, but I think this should be made by a DB_Table php script instead of being DB implementation specific.

I started a DB_Table script, but I noticed that there's not way to add constraints (PRIMARY key). Is there a way to add a primary key with DB_Table?

Hi, Jean-Philippe -- the short answer is "not exactly" and the long answer is "kind of". ;-) For now, specify a unique index on the column you want to use as a primary key; future versions of DB_Table will explicitly support primary and foreign key notations, and possibly other constraints as well. I know that's probably not the answer you wanted to hear; sorry. :-( -- Paul M. Jones Savant: the simple alternative to Smarty for PHP. http://phpsavant.com/ DB_Table: build RDBMS tables and XHTML forms in one PHP class. http://wiki.ciaweb.net/yawiki/index.php?area=DB_Table Yawiki: your collaborative online documentation system. http://yawiki.com/ Yawp: a single-file foundation for PHP applications. http://phpyawp.com/