X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 00760475FC8 for ; Thu, 10 Apr 2003 14:13:31 -0400 (EDT) Received: from hacklab.net (h-68-164-245-144.SNVACAID.covad.net [68.164.245.144]) by postgresql.org (Postfix) with SMTP id 03517475EDF for ; Thu, 10 Apr 2003 14:13:24 -0400 (EDT) Received: (qmail 23727 invoked by uid 421); 10 Apr 2003 18:08:30 -0000 Received: from pvspam-postgres@hacklab.net by penguin.hacklab.net by uid 417 with qmail-scanner-1.16 ( Clear:SA:0(-30.7/5.0):. Processed in 0.208276 secs); 10 Apr 2003 18:08:30 -0000 Received: from localhost (antispam@127.0.0.1) by localhost with SMTP; 10 Apr 2003 18:08:29 -0000 Subject: Re: PLEASE HELP ME URGENT about choosing only the ones From: Tim Ellis To: Himmet Karaman Cc: postgreSQL Help Center , pgsql-interfaces@postgresql.org, pgsql-general@postgresql.org, pgsql-novice@postgresql.org, pgsql-docs@postgresql.org In-Reply-To: <3E956C4F.20109@itu.edu.tr> References: <3E956C4F.20109@itu.edu.tr> Content-Type: text/plain Organization: PostgreSQL Admin Message-Id: <1049998385.2332.189.camel@timetop> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2-1mdk Date: 10 Apr 2003 11:13:05 -0700 Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-34.6 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,SUSPICIOUS_RECIPS, USER_AGENT_XIMIAN version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/180 X-Sequence-Number: 8335 On Thu, 2003-04-10 at 06:06, Himmet Karaman wrote: > Can anyone help me about how can i configure it to be able to choose > only some types of data (for example to enter the name of the city to > one of the columns [or fields] the one who is entering th data must be > able to choose only the cities that i want to be added and how can i You want code tables. You can enforce the referential integrity via triggers or, if you like living on the edge, in the application. This isn't a difficult problem, but nor is it the type of thing you'll get resolved on mailing lists. You need a database developer, or you need to get some books and become one yourself. -- Tim Ellis Senior Database Architect and author, tedia2sql (http://tedia2sql.tigris.org) If this helped you, http://svcs.affero.net/rm.php?r=philovivero