Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f215MJx67054 for ; Thu, 1 Mar 2001 00:22:19 -0500 (EST) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4) with HTTP id 1211827; Wed, 28 Feb 2001 21:22:18 -0800 From: "Josh Berkus" Subject: Re: [PHP] novice question To: "Andy Arledge" Cc: pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.4 Date: Wed, 28 Feb 2001 21:22:18 -0800 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="windows-1252" Content-Transfer-Encoding: 8bit X-Archive-Number: 200103/1 X-Sequence-Number: 1642 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 josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco