pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
novice question
2+ messages / 2 participants
[nested] [flat]

* novice question
@ 2001-03-01 03:08 Andy Arledge <mrgburg@att.net>
  2001-03-01 05:22 ` Re: [PHP] novice question Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Andy Arledge @ 2001-03-01 03:08 UTC (permalink / raw)
  To: pgsql-php <pgsql-php@postgresql.org>

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? 

thanks,

andy arledge
www.neighborhoodsingles.com

Attachments:

  winmail.dat (application/ms-tnef, 1.9K) download

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [PHP] novice question
  2001-03-01 03:08 novice question Andy Arledge <mrgburg@att.net>
@ 2001-03-01 05:22 ` Josh Berkus <josh@agliodbs.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Josh Berkus @ 2001-03-01 05:22 UTC (permalink / raw)
  To: Andy Arledge <mrgburg@att.net>; +Cc: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-03-01 05:22 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-01 03:08 novice question Andy Arledge <mrgburg@att.net>
2001-03-01 05:22 ` Josh Berkus <josh@agliodbs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox