| From: | "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com> |
|---|---|
| To: | "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com> |
| Cc: | "pgAdmin Support" <pgadmin-support(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: How to overwrite a table [only data]? |
| Date: | 2006-10-04 11:50:36 |
| Message-ID: | 7be3f35d0610040450v2cf4ea3cm24629e3caa925f9d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-sql |
Ezequias ,
>
> I would like to overwrite a table with problem with his original. But
> there are some points.
>
> I can't just delete and restore it becouse it has a foreign key and when I
> try to delete it ask for drop cascade.
>
> As I know the drop cascade delete in both tables the rows related. Is it
> correct ?
>
> You are right.
Your database structure disallows this kind of deletes.
So, if you want to allow it, you have to disable / remove that foreign key
restriction, refresh your data, and reimplement that restriction.
Be aware that foreign key restrictions usually are there for a reason.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Kirpa | 2006-10-04 14:49:43 | pgAdmin III v1.6 Beta 1 - Pg-8.2beta1: Grid editor problem |
| Previous Message | Ezequias Rodrigues da Rocha | 2006-10-04 11:40:15 | How to overwrite a table [only data]? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | christopher wood | 2006-10-04 13:35:42 | Re: Assigning a timestamp without timezone to a timestamp |
| Previous Message | Ezequias Rodrigues da Rocha | 2006-10-04 11:40:15 | How to overwrite a table [only data]? |