Replacing a table with constraints
| От | Mark Fenbers |
|---|---|
| Тема | Replacing a table with constraints |
| Дата | |
| Msg-id | 4284F421.10809@noaa.gov обсуждение исходный текст |
| Ответы |
Re: Replacing a table with constraints
|
| Список | pgsql-sql |
I have a table called Counties which partially contains a lot bad data. By" bad data", I mean some records are missing;some exist and shouldn't; and some records have fields with erroneous information. However, the majority of thedata in the table is accurate. I have built/loaded a new table called newCounties with the same structure as Counties,but contains no bad data. My was to completely replace the contents of Counties with the contents of newCounties. The problem is: several other tables have Foreign Key constraints placed on Counties. Therefore, Pg will notlet me 'DELETE FROM Counties;", nor will it let me "DROP TABLE Counties;" <br /><br /> I'm perplexed. Can someone suggesthow I can best get data from Counties to look just like newCounties?<br /><br /> Mark<br />
В списке pgsql-sql по дате отправления: