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
informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small
businesses fax 621-2533 and non-profit organizations. San Francisco