Re: May I have an assistance on CREATE TABLE Command
| От | Bart Degryse |
|---|---|
| Тема | Re: May I have an assistance on CREATE TABLE Command |
| Дата | |
| Msg-id | 48D0DDC1.A3DD.0030.0@indicator.be обсуждение исходный текст |
| Ответ на | May I have an assistance on CREATE TABLE Command (James Kitambara <jameskitambara@yahoo.co.uk>) |
| Ответы |
Re: May I have an assistance on CREATE TABLE Command
|
| Список | pgsql-sql |
I think (one of) the point(s) of id fields is not to change them. You can update the region_name field (eg a correct a misspelling), but the id stays the same.
That way the district stays connected to the same region.
>>> James Kitambara <jameskitambara@yahoo.co.uk> 2008-09-17 8:50 >>>
>>> James Kitambara <jameskitambara@yahoo.co.uk> 2008-09-17 8:50 >>>
Hello Mambers of PGSQL-SQL, I have two tables namely: REGION (region_id, region_name) DISTRICT (dist_id, dist_name, region_id (FK)) I would like to have the CREATE TABLE Command which will create these tables in such a way that when REGION table is UPDATED automatical the FOREGN KEY in DISTRICT table is also updated. I will appriciate for your assistance ! Regards James Kitambara |
В списке pgsql-sql по дате отправления: