Received: from mtiwmhc26.worldnet.att.net (mtiwmhc26.worldnet.att.net [204.127.131.51]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2137cx55587 for ; Wed, 28 Feb 2001 22:07:38 -0500 (EST) (envelope-from mrgburg@att.net) Received: from oemcomputer ([12.74.7.81]) by mtiwmhc26.worldnet.att.net (InterMail vM.4.01.03.16 201-229-121-116-20010115) with SMTP id <20010301030732.TUVP18067.mtiwmhc26.worldnet.att.net@oemcomputer> for ; Thu, 1 Mar 2001 03:07:32 +0000 From: "Andy Arledge" To: "pgsql-php" Subject: novice question Date: Wed, 28 Feb 2001 21:08:37 -0600 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0003_01C0A1CA.9E704F00" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Importance: Normal X-MS-TNEF-Correlator: X-Archive-Number: 200102/45 X-Sequence-Number: 184 This is a multi-part message in MIME format. ------=_NextPart_000_0003_01C0A1CA.9E704F00 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0003_01C0A1CA.9E704F00 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+IiUDAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcA GAAAAElQTS5NaWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEG gAMADgAAANEHAgAcABUACAAAAAMAFgEBA5AGAAQHAAAlAAAACwACAAEAAAAL ACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAABAAAAEAAAAG5v dmljZSBxdWVzdGlvbgACAXEAAQAAABYAAAABwKH85lppIHhZDagR1Z3lAOCY BJhmAAACAR0MAQAAABUAAABTTVRQOk1SR0JVUkdAQVRULk5FVAAAAAALAAEO AAAAAEAABg4AaGTS/KHAAQIBCg4BAAAAGAAAAAAAAABriidoHsnTEZ3kAOCY BJhmwoAAAAsAHw4BAAAAAgEJEAEAAADAAgAAvAIAAOADAABMWkZ1Nv3gQQMA CgByY3BnMTI1FjIA+Atgbg4QMDMzTwH3AqQE9AIAY2gKwHPQZXQwIAhQbQ3g BgSbBeACgH0KgAjIIDsJab0OIDgKIxQRAoAKgXYIkKR3awuAZDQMYGMAUA0L A2MAQQu0NCBpJ2BtIHJ1bgMADyAgkHBvc3QJwXNxAyCZAiAgYQqwEPBlIAPw hHRoF7BocDQuFvB7GJAXIHcFsBVRF6AZE2FrF7oBkWwY8WgN4BlAdwZhBCAR MSB1cCBiJnkYkAOgZW0LUG95UwngGGBmIBGgbhvyb/wgbh6wCQAPIASQGgME IH8CEAXAGTAY8AWgHZAAcHl/GaAZMAQAHXgctQWgAIB06nILcXQEIHQesCAS G7O+LBygA3Ad8xwVAiAnBUCXGhIXsANgcASQbHkjsFcIkBmgCXBqBZB0CYAg BmQKUCLiQ0hFQ0t9IikuCqIKhAqAHqAH4GTbHrAZwGYVYRhgdSTxEQD3BUAg ExjgYyVAIjoKwCAx7whwCXACMCXAPwrjKPkQ8b8fISp/IpMstihUFwB2GPB9 CQBjKlAmoQuAIAMG4G/XJUEX2B0hYhdAYxjwBGD8bWoHMAOgKRIi8Ry1IBT7 IlcjsGIqATDQJNIpozO12ymjAHF3BJAi13EKUBfg/mkiQRiQBuAwgBmgIJEz oExlbB0AGhB1bCawYv8zEhfgGJElYAWQBzAmkRmg/yheNeEtkghgAjAzowOB HTDedREwN6Er4gkAZx8wMRP/KlYsNBugB3EvjClQB5EgkXsCIBjwax7QB+Ae ERrgZ/8xsCawHtAVEDMBPeJCgANgyxzxH9JsC4B1eBhgBcDfGWIvjBkwAHAf oCwoWgBwfmQdMSWwCYAfMChYJrB3RUigLh5gaWdoBuBynx6gBHAAkA8gG+Bz LiBRCyhUEnEASvALAAGACCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAMA A4AIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwAHgAggBgAAAAAAwAAA AAAAAEYAAAAAUoUAACdqAQAeAAmACCAGAAAAAADAAAAAAAAARgAAAABUhQAA AQAAAAQAAAA5LjAAHgAKgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAAB AAAAAAAAAB4AC4AIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAA AAAeAAyACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAACwAN gAggBgAAAAAAwAAAAAAAAEYAAAAAgoUAAAEAAAALADqACCAGAAAAAADAAAAA AAAARgAAAAAOhQAAAAAAAAMAPIAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAA AAAAAwA9gAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAADAGmACCAGAAAA AADAAAAAAAAARgAAAAABhQAAAAAAAAsAfIAIIAYAAAAAAMAAAAAAAABGAAAA AAaFAAAAAAAAAgH4DwEAAAAQAAAAa4onaB7J0xGd5ADgmASYZgIB+g8BAAAA EAAAAGuKJ2geydMRneQA4JgEmGYCAfsPAQAAAIIAAAAAAAAAOKG7EAXlEBqh uwgAKypWwgAAUFNUUFJYLkRMTAAAAAAAAAAATklUQfm/uAEAqgA32W4AAABD OlxXSU5ET1dTXExvY2FsIFNldHRpbmdzXEFwcGxpY2F0aW9uIERhdGFcTWlj cm9zb2Z0XE91dGxvb2tcb3V0bG9vay5wc3QAAAADAP4PBQAAAAMADTT9NwAA AgF/AAEAAAAvAAAAPE5EQkJKTk9FR0xHS0xQR01JR0tQT0VMQUNDQUEubXJn YnVyZ0BhdHQubmV0PgAAAwAGEFsZN+oDAAcQUAIAAAMAEBAAAAAAAwAREAAA AAAeAAgQAQAAAGUAAABJTVJVTk5JTkdQT1NUR1JFU1FMT05BUEFDSEVXSVRI UEhQNElBTVdPUktJTkdXSVRIQVBPU1RHUkVTUUxUQUJMRVdISUNIV0FTU0VU VVBCWUFORU1QTE9ZRUVPRk1JTkVXSE9OAAAAAPOZ ------=_NextPart_000_0003_01C0A1CA.9E704F00--