Andy, I'm forwarding your e-mail to the PGSQL-SQL list, where I think you'll find more help on CONSTRAINTS. As I don't use them a lot, myself, I don't have a good answer for you. > i'm running postgresql on apache with php4. i am working with a > postgresql > table which was set up by an employee of mine who no longer works for > the > company. this employee set up constraints to the table, some of which > won't > work properly, ie. rejected due to CHECK constraint. > > how do i find out what the check constraints are currently? > how do i change the check constraints? > > i've located in the book postgresql by bruce momjian how to set up > the > constraints, but can't find how to find answers to the questions > above. any > help would be most appreciated. > > how can i count how many users are logged in at the current time? > does anyone know of a good novice user group for linux or php4? > andy arledge > www.neighborhoodsingles.com Hmmm ... Andy, I think you may have bitten off more than you can chew. While I bootstrapped my own knowledge of Linux and PostgreSQL, it took me over a year before I was comfortable administrating professionally ... and I haven't learned PHP yet! Unfortunately, I haven't found any one book that helped me with everything. For example, for Linux administration, I bought and read "Linux Administration for Beginners"(Osborne), "Linux Administration"(O'Reilly) and "Linux in a Nutshell" (O'Reilly). And I still hire specialists for complex networking. Good Luck! -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology [EMAIL PROTECTED] and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco