The web-interface shouldn't have to set it at all, if a default value is specified you don't have to explicitly set that field :)
However I just noticed I made a typo in the RELEASE.NOTES, it should read: ALTER TABLE users ADD COLUMN maxlogins INT4 DEFAULT 1; and not: ALTER TABLE users ADD COLUMN maxlogins INT4 DEFAULT '1'; If you want to fix your existing table, you can do this: ALTER TABLE users ALTER COLUMN maxlogins SET DEFAULT 1; You can type "\d users" to see if the changes have taken effect. Cheers, Greg. [EMAIL PROTECTED] wrote on 28/02/2002 21:38:28: > Are you using the most recent version of the web interface? If not, > download the latest version, it may set the maxlogins field properly > whereas an older version may not.... > > > >Did you set the default value of the 'maxlogins' columns to be '1'? > > > >-- > >Alex Badea > > > >Yes I did.. > > > >[gnuworld@comet gnuworld]$ psql cservice > >Welcome to psql, the PostgreSQL interactive terminal. > > > >Type: \copyright for distribution terms > > \h for help with SQL commands > > \? for help on internal slash commands > > \g or terminate with semicolon to execute query > > \q to quit > > > >cservice=# > > > >cservice=# UPDATE users SET maxlogins = 1; > >UPDATE 9 > >cservice=# > > > >I need to do that everytime some one have register a new username and > >restart gnuworld.. > > > >-Comet- > >
