Re: PLEASE HELP ME URGENT about choosing only the ones

From: Tim Ellis <pvspam-postgres(at)hacklab(dot)net>
To: Himmet Karaman <karamanhi(at)itu(dot)edu(dot)tr>
Cc: postgreSQL Help Center <pgsql-admin(at)postgresql(dot)org>, pgsql-interfaces(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org
Subject: Re: PLEASE HELP ME URGENT about choosing only the ones
Date: 2003-04-10 18:13:05
Message-ID: 1049998385.2332.189.camel@timetop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-docs pgsql-general pgsql-interfaces pgsql-novice

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Treat 2003-04-10 18:51:57 Re: pg_class.reltuples not reset by VACUUM?
Previous Message Radu-Adrian Popescu 2003-04-10 14:42:22 Re: Programms working on a PostgreSQL database written in C++?

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2003-04-11 20:34:14 Re: 6.8.5: Location of CURRENT_DATE unclear
Previous Message Himmet Karaman 2003-04-10 13:06:23 PLEASE HELP ME URGENT about choosing only the ones that i want while entering the data to postgresql with pgaccess on linux or windows or pgadmin II

Browse pgsql-general by date

  From Date Subject
Next Message Delao, Darryl W 2003-04-10 18:33:09 Remote logging in postgres
Previous Message Tom Lane 2003-04-10 18:04:00 Re: Corrupt index

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2003-04-10 18:15:13 Re: More thoughts about FE/BE protocol
Previous Message Michael Meskes 2003-04-10 17:20:04 Re: ECPG thread-safety

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-04-10 18:20:12 Re: Data types mapping
Previous Message Tom Lane 2003-04-10 17:56:29 Re: connect to database over network